Tuesday, 25 June 2013

Insert Row with Identity


To insert values with a specific id use the following code this will insert a line of data with a defined id.

Beware whilst this is running NO AUTO IDENT WILL WORK keep every one away from this table.

SET IDENTITY_INSERT Table name ON

  INSERT table name (UID, Value) VALUES (2006, 'any value')

  SET IDENTITY_INSERT Table name OFF
If this fails due to a syntax error in the insert statement then  the Identity will remain OFF
-
Labels: , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Samsung Android Keyboard

  If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and ...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • Restore Windows App after a Crash.
    If you have a situation that requires an application to always be up then try   Restart program after a crash downloadable from  https://w-s...