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

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

Explain the commands in sql server?

0 Answers  

---

What's the difference between a primary key and a unique key?

4 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

How to define and use table alias names in ms sql server?

0 Answers  

---

What is compression - row-level and page-level compression?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

---

How do I shrink an ldf file?

0 Answers  

---