Re: Error on insert to

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/04/04

  • Next message: marty: "how do I select len(foo) for an ntext field?" 
    Date: Tue, 4 May 2004 20:58:46 +0530

    hi garry,

    you will have to SET option identity_insert on the table. also while
    inserting you will have to specify column list.

    ex:

    set identity_insert <table> on
    insert into <table> (col1, col2) values(1,1) 

    -- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
  • Next message: marty: "how do I select len(foo) for an ntext field?"