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