Wednesday, December 16, 2009

convert float to varchar nvarchar

When we import Excel data into SQL table it will create columns with 'Float' data type.
Here is the little trikey to convert float value to varchar/nvarchar


select top 1 convert(varchar,cast(floatNumber as decimal)) n from dbo.Mytable

Saturday, December 12, 2009

hardest interview question job site

1 Hardest Job Interview Question

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=10692981&gid=40717&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA

Top 100 Niche Job Sites
http://newgradlife.blogspot.com/2009/12/top-100-niche-job-sites.html

sql server with TB how to manage data

good article, worth to read when you have large amount of data (TB)

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=10740201&gid=59185&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBAjavascript:void(0)

Using Timer in Windows Services

http://www.developer.com/net/net/article.php/3335731/Using-Timers-in-a-Windows-Service.htm

Using Google Map API in your Web application

http://aspsnippets.com/post/2009/04/15/Using-Google-Maps-API-in-ASPNet.aspx

Friday, November 27, 2009

Tuesday, November 10, 2009

Dell Inspiron 1525 lock with 9

Press Fn + Power key & see the below chart

--Here is the chart
http://support.dell.com/support/topics/global.aspx/support/dsn/en/document?c=us&cs=19&dl=false&l=en&s=dhs&docid=DBECF64CFEDA449398CB9E859D4944A5&doclang=en