T-SQL GO statement

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by mike l » T-SQL GO statement

47 posts, Page 5 of 5

«««1 2 3 4 5

T-SQL GO statement

Rate Topic

Display Mode

Topic Options

Author

Message

SQLRNNR

Posted Wednesday, November 24, 2010 10:46 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

thanks for the question

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1026042

Dhruvesh Shah

Posted Thursday, November 25, 2010 8:52 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542, Visits: 187

Excellent question. i thought # is not valid table name but googling suggest that it's valid.

Post #1026620

Dhruvesh Shah

Posted Thursday, November 25, 2010 8:54 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542, Visits: 187

Great thanks. didn't know that. learnt something new.

Post #1026622

UMG Developer

Posted Friday, December 03, 2010 1:24 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question!

Post #1030129

supremepss

Posted Monday, December 06, 2010 11:45 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 04, 2011 12:19 AM
Points: 103, Visits: 10

hi...
yes u r correct sir/madam, me too get the same results when i am executing the below statement

insert into #
select 'asdf'
go 100
but after that , u said to drop the table in the queryy editor means (drop table #), then the answer is # is an invalid table name knw......... So how we can get 101

Post #1031051

durai nagarajan

Posted Tuesday, February 15, 2011 5:14 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 851, Visits: 2,099

Hi,

i am getting error like this as expected, kindly suggest as it is not matching with the answer.

(1 row(s) affected)

Server: Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '100'.

Regards
Durai Nagarajan

Post #1064177

Hugo Kornelis

Posted Tuesday, February 15, 2011 5:54 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 5,235, Visits: 7,034

Durai, what are you using as the client? SSMS supports this since version 2005 (maybe even earlier). I don't know about the other tools.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #1064195

« Prev Topic | Next Topic »

47 posts, Page 5 of 5

«««1 2 3 4 5

Permissions