Post reply

GO

  • June 7, 2011 at 9:23 am

    #1335091

    Steve Jones - SSC Editor (6/7/2011)

    My apologies. The question has been corrected with a count(*) instead of a SELECT *. I am sure that I saw 50 results in testing and let it go as "there were 50 rows", thinking the question was testing the "go 50" and you'd all be able to read the author's mind.

    I will award back points as soon as my VPN is repaired.

    Now what kind of holidays is that???

    Back to the horses or I tell your wife :hehe:.

  • June 7, 2011 at 9:40 am

    #1335103

    Ninja's_RGR'us (6/7/2011)

    Now what kind of holidays is that???

    Back to the horses or I tell your wife :hehe:.

    I'm pretty sure he didn't ride horses down to Florida which is where I gather he is from his blog post. If he did, more props to him. That's a nice, long vacation.

  • June 7, 2011 at 9:40 am

    #1335106

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 7, 2011 at 9:52 am

    #1335124

    Lucky guess and a great question! 🙂 Thanks! Cool function.

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • June 7, 2011 at 9:56 am

    #1335129

    cfradenburg (6/7/2011)

    Ninja's_RGR'us (6/7/2011)

    Now what kind of holidays is that???

    Back to the horses or I tell your wife :hehe:.

    I'm pretty sure he didn't ride horses down to Florida which is where I gather he is from his blog post. If he did, more props to him. That's a nice, long vacation.

    No horses, just swimming with my little girl. The VPN broke just before I was to leave, and apparently hasn't been fixed.

  • June 7, 2011 at 2:59 pm

    #1335360

    I got around to this question late today so I missed all of the excitement. I never knew that 'GO' accepted a count. Never read about 'GO'...HA! Thanks for the lesson.

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

  • June 7, 2011 at 4:53 pm

    #1335397

    Re: the squiggly red underline after the GO command

    Good to know they've got it fixed in the updates, minor things but still a good fix 😀

    Urbis, an urban transformation company

  • June 8, 2011 at 7:13 am

    #1335632

    It's a nice question now that it says "count(*)". It wasn't really all that bad before, just a bit disconcerting.

    Tom

  • June 17, 2011 at 7:30 am

    #1340412

    What a load of whingers :Wow:

    How come you did not whinge about no mention of using SSMS and at least 2005 to even get close to one of the answers 😛

    Far away is close at hand in the images of elsewhere.
    Anon.

  • June 23, 2011 at 9:08 pm

    #1343463

    great question. I never realised Go accepted an option... now I just need to find a use for it 😉

Viewing 10 posts - 46 through 54 (of 54 total)

You must be logged in to reply to this topic. Login to reply