Answer / p.s jayagopal

Identity(or Auto Number) is a column which automatically
generates numeric values.It will be mainly used for a column
which is set as primary key and which doesn't allow null value.

Answer / magu

Identity (or AutoNumber) is a column that automatically
generates numeric values. A start and increment value can
be set, but most DBA leave these at 1. A GUID column also
generates numbers; the value of this cannot be controlled.
Identity/GUID columns do not need to be indexed.

Syntax :

IDENTITY ( seed, increment )

Explain partitioned view?

0 Answers  

---

What is difference between foreign key and unique key?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What are the OS services that the SQL Server installation adds?

3 Answers  

---

What is transaction server implicit?

0 Answers  

---

Which system tables contain information on privileges granted and privileges obtained

1 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

List the types of recovery model available in sql server?

0 Answers  

---