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, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
This is a good one - ending the week on a high note. Thanks, Kenneth!
Post #1356304
Posted Saturday, September 8, 2012 7:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:32 PM
Points: 11,194, Visits: 11,140
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: Thursday, August 21, 2014 5:59 AM
Points: 897, Visits: 1,488
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: Today @ 8:12 AM
Points: 571, Visits: 341
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: Tuesday, December 10, 2013 4:26 PM
Points: 582, Visits: 451
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: Wednesday, August 6, 2014 12:09 AM
Points: 302, Visits: 178
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: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
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