How to Set Identity in Sql Server 2005 or 2008 ? — Identity reset , Sql Server — ASP.Net Example
ASP.Net Example-How to Set Identity in Sql Server 2005 or 2008 ?

Tuesday, June 19, 2012

How to Set Identity in Sql Server 2005 or 2008 ?

You have Sql Table Which Having for Example 20 Records. And Identity also 20. Now you want insert new Record with Identity 100 then you pass 99 in below function as Parameter and Table Name and Reseed .
DBCC CHECKIDENT (TableName, reseed, 99)

1 comment:

  1. well this was very nice article and very good information for ASP.NET learners i was really satisfied see this information we also provide ASP.NET Online Training

    ReplyDelete

ASPdotNET-Example