Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

T-SQL GO statement Expand / Collapse
Author
Message
Posted Wednesday, November 24, 2010 10:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 17,600, Visits: 15,462
thanks for the question



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


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
Posted Thursday, November 25, 2010 8:52 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Excellent question. i thought # is not valid table name but googling suggest that it's valid.
Post #1026620
Posted Thursday, November 25, 2010 8:54 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Great thanks. didn't know that. learnt something new.
Post #1026622
Posted Friday, December 3, 2010 1:24 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question!
Post #1030129
Posted Monday, December 6, 2010 11:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 4, 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
Posted Tuesday, February 15, 2011 5:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Posted Tuesday, February 15, 2011 5:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:36 PM
Points: 6,002, Visits: 8,267
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 »

Add to briefcase «««12345

Permissions Expand / Collapse