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 use column default values in insert statements in ms sql server?

990

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

930

---

How can delete duplicate records in cte in sql server?

919

---

how to overcome kernel isssues

1581

---

How to delete multiple rows with one delete statement in ms sql server?

954

---

What is DCL?

994

---

how can you check the level of fragmentation on a table? : Sql server administration

930

---

What are the different types of replication you can set up in sql server?

999

---

What is page in sql server?

908

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1016

---

What to check if a User database is locked?

1030

---

What are the advantages of log shipping?

935

---

What is function of ROLLUP ?

1046

---

Should you normalize audio?

891

---

How does using a separate hard drive for several database objects improves performance right away?

896

---