Forum Replies Created

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

  • RE: T-SQL

    You are correct - I'm an idiot!

    I guess I never tried inserting without column names being explicitly stated, but it does indeed work.

    don

    January 3, 2011 at 12:28 pm

    #1268634

  • RE: T-SQL

    Actually, I'm right - this query will return 0 rows for both SELECT statements as it will never run - you cannot insert into a table with and Identity PK...

    January 3, 2011 at 10:13 am

    #1268557

  • RE: Format/Transpose table data to Columns and Rows.

    How about using Dynamic SQL - not the greatest for security, but it does work!  I would wrap it up in a proc. 

     

    DECLARE...

    April 15, 2005 at 5:40 pm

    #553031

  • RE: ADO doesnt connect without network

    Have you tried using a loopback connector?

     

    November 19, 2004 at 2:13 pm

    #530909

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