Answer / muthu kumar

create table t(id int identity(seed,increment))

where seed is starting number and increment is number to be
incremented.

create table t(id int identity(1,1),name varchar(50))

so the id will be start with 1 and will be incremented 1 by
1 each time when record is get insered

Answer / adhi

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

Answer / yvbchowdary

The identity is similar to squence object in oracle. syntax
for identity column is
<column-name> <data type> identity(start value,increment)
ex:
empno int identity(100,2)

suppose if u want to add an odd value i.e, 50; u can also
add
first execute IDENTITY_INSERT ON
and then u can insert whatever values u want. then again
execute IDENTITY_INSERT OFF

What is query processing?

0 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

What are the commands used in DCL?

0 Answers  

---

What stored procedure can you use to display the current processes?

0 Answers  

---

What is faster join or union?

0 Answers  

---

Explain multiserver query

0 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

what is the difference between table and view

1 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

What is importing utility?

0 Answers  

---