Friday 3 June 2011

How to Insert data manually into identity column of a table ?

      • set identity_insert  my_table on

      • insert into my_table(my_id,first_name,last_name )
      • values (3,'raju','kumar1')

      • set identity_insert my_table off

No comments:

Post a Comment