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 a self join? : Sql server database administration

0 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

Can we insert data into view sql server?

0 Answers  

---

How to retrieve error messages using mssql_get_last_message()?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---

What is the usage of sign function?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---