var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a database table and it has a column called ttt_id which has an identity seed. Now the Id value is 2845746 and if I insert the new record the value would be 2845747. But I want to change that to 2865740 instead of 2845747. How can do that?
Check out DBCC CHECKIDENT in BOL. It should give you everything you need.
-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT <TableName> ON
INSERT INTO <TableName> (<FieldName>) VALUES(2845747)
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors