Gasoline Humor - Pictures paint a thousand words.

ATT00022

ATT00082

ATT00055

ATT00046

If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !

MS SQL - Find MAX value from varchar/nvarchar field.

Can you guess which one is a max number if the data type for the field is not an integer ? perhaps it is varchar or nvarchar field.

10
1
2
3
14
15
9
8

The answer is 9. I believe it is because ascii value for 9 = 57 and the ascii value for 25 = 50

ascii value

Then, how you want to get the max value using SQL command ?

Read the rest of this entry »

Export SQL result to CSV file easily.

 

Microsoft Excel (Windows)

Image via Wikipedia

 

Have you ever experience with excel limitation that only allow you to store up to certain row of data ?

 

If not, then I just want to share with you that Excel limit only 65,536 rows per worksheet. If you have more than 65,536 records, then you no choice, need to put it in another worksheet and this will be troublesome.

excel the end

The easiest way to get rid of this limitation is to put your data in csv file.There are no limitation on how many records you want to put into it.

Using SQL Query Analyzer, you can export your result set to textfile but not to csv file.

Read the rest of this entry »

Ubuntu Hardy Heron FREE CD arrived

I already upgrade my ubuntu to Hardy Heron last month. But then, I still order for FREE ubuntu CD throught ShipIT. I request for 5 CD’s :)

Yesterday I received it and already give the CD’s to my bos and my colleague. I still have 2 extra CD to keep it for myself. :)

If you have your home network configuration similar to me then you can straight away enjoy your internet connection using Live CD. No additional configuration required. But this only applicable if you are connected using RJ45 cable and not the wireless connection.

I think it would be much much helpful if ubuntu by default comes with wireless capabilities

myHardyLiveCD2

Wow, we can add new program even we are using Live CD. :)

myLifeCD3

 

 

 

 

 

 

 

 

 

Have you got your ubuntu CD ?