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 )

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

what is sql server? : Sql server database administration

0 Answers  

---

What are the acid properties?

0 Answers  

---

What is use of except clause?

0 Answers  

---