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 )

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

What do you understand by check constraint in sql server?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

What is shrink log file?

0 Answers  

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

---

What is use of dbcc commands?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

Questions on identity?

2 Answers   Infosys,

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

How do I view a stored procedure in sql server?

0 Answers  

---