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 are indexers?

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Can we insert data into view sql server?

0 Answers  

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

What is rank function?

0 Answers  

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---