Forums » Toad for SQL Server General

Thread: Issue using GO T-SQL keyword

This question is answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 2 - Pages: 1 - Last Post: Mar 7, 2012 8:01 AM by: noonand Threads: [ Previous | Next ]
noonand


Posts: 2
Registered: 2/22/12
Issue using GO T-SQL keyword
Posted: Feb 22, 2012 6:26 AM
 
  Click to reply to this thread Reply

Many people are not aware of it but you can suffix the GO keyword with a number to make the preceding statment execute x number of times

SELECT NEWID()
GO 5

The number is being flagged by TOAD's T-SQL parser as an error when it is not (the same query executes perfectly in SSMS)


Julia Ponomareva


Posts: 78
Registered: 11/15/11
Re: Issue using GO T-SQL keyword
Posted: Feb 22, 2012 9:08 AM   in response to: noonand
 
  Click to reply to this thread Reply

Hello!

We have created CR#96560 and will fix it.

Thanks!

Kind regards, Julia.


QC Analyst | R&D | Quest Software is now part of Dell
noonand


Posts: 2
Registered: 2/22/12
Re: Issue using GO T-SQL keyword
Posted: Mar 7, 2012 8:01 AM   in response to: Julia Ponomareva
 
  Click to reply to this thread Reply

Thanks Julia


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums