IDENT_CURRENT->
Returns the last identity value generated for a specified table in any session and any scope.
Select ident_current('Table_Name')
-> Checks the current identity value for the specified table and, if needed, corrects the identity value.
By using Following Syntax-
dbcc checkident (Table Name,Reseed,1020000)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment