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

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

What is the difference between left and right outer join?

0 Answers  

---

What does ss stand for sexually?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

How to find table changes in sql server?

0 Answers  

---

How to define the name and server for a new dsn?

0 Answers  

---

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

---