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

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What is optimistic concurrency?

0 Answers  

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

One table how may column and Primary key

3 Answers  

---

Explain system views?

0 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

What is the full form of ddl?

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---