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)
Posted by Software Devloper at 10:34 AM
Labels: ,

2 comments:

  1. UnknownMarch 13, 2015 at 11:30 PM

    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
  2. Buy Contact LensesSeptember 26, 2017 at 12:12 PM

    It was really useful on behalf of American state. Keep sharing such ideas among the long run equally. This was really what i wont to be probing for, which i'm glad to came here! Thanks for sharing the such knowledge with USA.

    ReplyDelete

Subscribe to: Post Comments (Atom)
ASPdotNET-Example