Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kenneth Fisher » GO Part 1
Add to briefcase
38 posts, Page 4 of 4
«««1234

GO Part 1 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Revenant
Posted Friday, September 07, 2012 5:38 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:00 PM
Points: 3,459, Visits: 2,535
This is a good one - ending the week on a high note. Thanks, Kenneth!
Post #1356304
Paul White
Posted Saturday, September 08, 2012 7:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 10,990, Visits: 10,540
Good question, thanks Kenneth.


Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1356438
codebyo
Posted Sunday, September 09, 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, May 16, 2013 5:30 AM
Points: 861, Visits: 1,436
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
Yokers
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: Wednesday, May 15, 2013 6:48 AM
Points: 533, Visits: 260
good question, caught me out!
Post #1356818
Olga B
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, March 22, 2013 5:58 PM
Points: 561, Visits: 440
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
Keld Laursen (VFL)
Posted Tuesday, September 18, 2012 12:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 7:36 AM
Points: 245, Visits: 148
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
Robin Sasson
Posted Tuesday, September 18, 2012 5:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, February 18, 2013 6:17 AM
Points: 674, Visits: 472
Great question thanks.

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:48 AM
Points: 2,440, Visits: 714
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
38 posts, Page 4 of 4
«««1234

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.