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 the fillfactor concept in indexes?

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

What is the process of indexing?

0 Answers  

---