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
Wednesday, December 16, 2009
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
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)
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
Subscribe to:
Posts (Atom)