Results 1 to 2 of 2

Thread: identity insert

  1. #1
    Join Date
    Jan 2002
    Posts
    3

    Unanswered: identity insert

    is there any way to force mssql to insert user defined value in identity column?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    check out SET IDENTITY_INSERT in books on line.

    assume a table called ABC and the xyz field is an identity...

    SET IDENTITY_INSERT ABC on
    insert into ABC (xyz, filed2, field3, ...)
    select 14, 'A','B',....
    SET IDENTITY_INSERT OFF
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •