DBCC CHECKIDENT (‘table_name’, reseed, 34)
If identity seed is set below values that currently are in table, it will violate the uniqueness constraint as soon as the values start to duplicate and will generate error.
I have created this blog to help those who are looking for a change in .Net. You can share your interview experience, problems and knowledge. Just mail your content at firstname.lastname@example.org. It will immediately published. Visit the blog for .Net FAQ,.Net interview questions,ASP .Net FAQ, C# .Net FAQ,ASP .Net interview questions, interview question on .Net, interview questions on C#.Before going to interview just go through the site.
We can assign a value to a readonly variable at runtime (in constructor only) till it is a unassined identifier, but once value is assigned, it cannot be changed. In case of const we cannot assign a value at run time i.e. the value assigned to it at declaration time cannot be change