var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have an IDENTITY field (used as a primary key) that increments sequentially when a new row is added. The data will be deleted\refreshed periodically and I want to reset the Identity field back to 1. How can I do this?
set IDENTITY_INSERT ON
insert the value of 1 into the IDENTITY column
set IDENTITY_INSERT OFF
From then on, it will reset from 2 onwards
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors