Home Forums SQL Server 2008 T-SQL (SS2K8) Inserting auto increment values through Identity RE: Inserting auto increment values through Identity

  • October 4, 2013 at 12:39 am

    #1655751

    Hi,

    It should work...

    Run the below statement and then insert values..

    SET IDENTITY_INSERT IdentityProducts OFF

    insert into IdentityProducts(productname,categoryid,unitprice)

    values

    ('shad',1,100)