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

How to provide values to user defined function parameters?

966

---

Explain what are magic tables in sql server?

946

---

What is the difference between web edition and business edition?

111

---

What is the importance of a recovery model?

999

---

What is transaction server explicit transaction?

968

---

What is temporal data type?

868

---

What are the authentication modes in sql server? How can it be changed?

1052

---

How do I uninstall sql server 2014?

871

---

Does partitioning ssd reduce performance?

845

---

How do I find query history in sql server?

873

---

Do you know what are acid properties?

1018

---

What are secondary xml indexes?

983

---

How connect excel to sql server?

928

---

What is the definition for sql server 2000?

1039

---

Why should we go for stored procedures? Why not direct queries?

1025

---