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 )

How many triggers you can have on a table?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

What is normalization process?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

Do you know what is rank function?

0 Answers  

---

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---