Answer Posted / 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

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1046

---

What are the results of running this script?

933

---

What is the difference between rank and dense_rank?

1090

---

What is 2nf in normalization?

1003

---

How to deploy the Report?

138

---

Does sql server 2016 have ssms?

963

---

Can you use order by when defining a view?

979

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

985

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1208

---

Where actually sql azure database is hosted?

163

---

What is meant by dirty read?

996

---

How would you go about developing a ssrs report?

168

---

What is blocking and how would you troubleshoot it? : sql server database administration

1049

---

what are candidate key, alternate key and composite key? : Sql server database administration

919

---