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
Subscribe to:
Post Comments (Atom)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
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... -
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...
No comments:
Post a Comment