Difference between SET & SELECT in TSQL

-
The following Two blogs explains difference between SET & SELECT When assigning values to local variables.

http://vyaskn.tripod.com/differences_between_set_and_select.htm


http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx

Comments

Post a Comment

Popular posts from this blog

Windows Azure Package Build Error: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

-
Image
I often see when packaging Windows Azure project getting "The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters." error. To fix this issue I had to change Cloud Project User options file add add ServiceOutputDirectory entry to the file. 1) Open your Cloud Project file in Windows Explorer from Visual Studio. 2) Find Cloud Project file in opened directory (*.ccproj file) 3) Open file in Notepad 4) Add c:\azure entry Now your cloud visual studio project user options file looks similar to below: 5) Save file and open your solution again. 6) Package Solution and it should package without above error.
Read more

Reset user settings on Visual Studio

-
Sometimes we might have created connection strings with different environments and don't want to save in entity framework wizard. Today I realized we can't modify/delete individual connection string from wizard. In order to delete saved connection strings from wizard we need to reset the user data. You can run the following command to reset user data on Visual studio: 1) Open Command Prompt 2) Goto C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE 3) Run devenv/resetuserdata It clears your profile  Visual studio settings and you can start creating new connection strings, which will be saved into your profile again.
Read more

How to get Client's Location using IPAddress

-
You can consume free Web Service, which can give IP Address Location Details. http://www.aspsnippets.com/post/2009/04/12/Find-Visitors-Geographic-Location-using-IP-Address-in-ASPNet.aspx The Following function returns Location Details as DataTable: private DataTable GetLocation( string ipaddress) { //Create a WebRequest WebRequest rssReq = WebRequest .Create( "http://freegeoip.appspot.com/xml/" + ipaddress); //Create a Proxy WebProxy px = new WebProxy ( "http://freegeoip.appspot.com/xml/" + ipaddress, true ); //Assign the proxy to the WebRequest rssReq.Proxy = px; //Set the timeout in Seconds for the WebRequest rssReq.Timeout = 2000; try { //Get the WebResponse WebResponse rep = rssReq.GetResponse(); //Read the Response in a XMLTextReader XmlTextReader xtr = new XmlTextReader (rep.Get...
Read more