USE AdventureWorks; GO DBCC CHECKIDENT ("HumanResources.Employee&quo

how to rest identity columns in sql server

Question Posted / adhi

Answer Posted / adhi

USE AdventureWorks;
GO
DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 300);
GO

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we perform backup restore operation on tempdb? : sql server database administration

1003

What is the syntax for encrypting a column in SQL Server?

1126

How exceptions can be handled in sql server programming?

1019

What is transact-sql language?

1100

What is the use of commit?

1004

What do you understand by sql server agent?

980

What is user-defined inline table-valued function?

962

When I delete any data from a table, does the sql server reduce the size of that table?

1025

When would you use a before or after trigger?

915

What do you understand by triggers and mention the different types of it?

950

What is cursors? And what are the different types of cursor?

1147

What is the concept of optimization?

1063

what's new in sql server 2016?

957

What is buffer cash in sql server?

1160

What are the authentication modes in sql server? How can it be changed?

1136