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 «««1234

GO Part 1 Expand / Collapse
Author
Message
Posted Friday, September 7, 2012 5:38 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
This is a good one - ending the week on a high note. Thanks, Kenneth!
Post #1356304
Posted Saturday, September 8, 2012 7:59 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
Good question, thanks Kenneth.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1356438
Posted Sunday, September 9, 2012 2:04 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:37 AM
Points: 904, Visits: 1,491
Richard Warr (9/7/2012)
I looked at the first option and was disappointed that the second one wasn't
Collect $200 for parsing GO.




Loved the question BTW. No catch, just expected behavior.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1356505
Posted Monday, September 10, 2012 9:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 13, 2014 7:04 AM
Points: 571, Visits: 355
good question, caught me out!
Post #1356818
Posted Wednesday, September 12, 2012 5:38 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:57 PM
Points: 582, Visits: 453
The benefit of replying a few days later and fully caffeinated. :D

Even so, I almost missed the INSERT ... SELECT part.

Fun question, and yes, a helpful technique for populating tables with large amounts of test data.
Post #1358270
Posted Tuesday, September 18, 2012 12:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:37 AM
Points: 305, Visits: 180
Damn!
Got the go part right, but didn't read the select closely enough.
But good to remember this way to create an exponentially rising number of records in a hurry.

Thank you for the question.
Post #1360580
Posted Tuesday, September 18, 2012 5:38 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
Great question thanks.

"Be brave. Take risks. Nothing can substitute experience."
Post #1360703
Posted Saturday, September 29, 2012 1:36 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:27 AM
Points: 2,670, Visits: 783
Nice that you can't "GO" in a T-SQL statement. What a nightmare that would be for anyone trying to avoid SQL Injection issues.

Jamie
Post #1366212
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse