Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: What is the result ? (SQLServer 2005)

    Ian Elliott (9/10/2008)

    So because I got the question wrong, because like many I checked my answer in QA before I chose it, and the question did not specifically mention the...

    September 10, 2008 at 11:05 am

    #869821

  • RE: What is the result ? (SQLServer 2005)

    imagine you need to generate 100 random numbers?

    You can hit F5 100 times or use go 100.

    September 10, 2008 at 7:44 am

    #869631

  • RE: What is the result ? (SQLServer 2005)

    skyline666 (9/10/2008)

    ALZDBA (9/10/2008)

    Keep in mind SSMS has some issues with e.g. char(13) resulting in a "syntax error near ...."

    And off course you'll need to have the default 'go' for...

    September 10, 2008 at 4:47 am

    #869509

  • RE: What is the result ? (SQLServer 2005)

    probably Query Analyser doesn't recognize GO [count] syntax.

    That proves that Query Analyser has it own syntax validation!

    September 10, 2008 at 3:51 am

    #869477

  • RE: Identity Columns

    rudy komacsar (7/7/2008)

    Curte question ... a fairly obvious solution ...

    However, why would one do such a thing ?

    I can't see why we would have a table with only an identity,...

    July 7, 2008 at 12:28 pm

    #839091

  • RE: Identity Columns

    Dariusz Czechowicz (7/7/2008)

    Here is an alternative solution without 'set identity_insert' 😉

    INSERT INTO TEST WITH (KEEPIDENTITY) (Col1)

    SELECT IDENT_CURRENT('Test') FROM OPENROWSET(BULK N'C:\boot.ini', SINGLE_BLOB) AS a

    We allways have the hard way to do...

    July 7, 2008 at 10:13 am

    #839015

Viewing 6 posts - 1 through 6 (of 6 total)