Browse by Tags

Fun with GO
05 September 08 08:58 AM | Madhivanan | 3 Comments   
In this blog post , I explained different uses of GO command Here is a Fun when you use GO as object name CREATE PROCEDURE GO ( @I INT ) AS SELECT @I AS number Well. The procedure is created and let us try to execute GO 2 What we see is Command ( s ) Read More...
Filed under: , ,
Another use of GO command in SQL Server 2005
06 August 08 07:07 AM | Madhivanan | 2 Comments   
As you all know, GO command signals the end of the batch of T-SQL statements However in SQL Server 2005, it is also used to execute set of commands for a specified number of times Consider that you want to create a table that should have hundred random Read More...
Filed under: , ,