Browse by Tags

Fun with GO

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 ) completed successfully Becuase it becomes a syntax...

Posted to Madhivanan (Weblog) by Madhivanan on Fri, Sep 5 2008
Another use of GO command in SQL Server 2005

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 integer values. You can the methods like the ones...

Posted to Madhivanan (Weblog) by Madhivanan on Wed, Aug 6 2008

Page 1 of 1 (2 items)

SQL Server Blogs