Wednesday, March 8, 2017

How to reset column identity in SQL server?

Sometimes we delete rows from a table and the identity will not start as expected from one, it would assign a random value. In order to reset the value we have to use the following command.

DBCC CHECKIDENT ('[TableName]', RESEED, 0);
GO
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Call a function in child component from parent component in React

Consider the following parent component class Parent extends React.Component { constructor(props) { super(props);         thi...

  • what is the difference between web service and a web application?
    Web Application:Any application which we can run in our web browser is a web application. Web Service:A web service is an Application Prog...
  • Explain Amazon Cloudfront
    Amazon cloudfront offers a simple cost effective way to improve the performance, reliability and global reach of your entire website for s...
  • p5.js
    p5.js is a JavaScript library which can be used by artists,designers,educators and beginners who want to code. Using p5.js we have a full se...