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 identify current user in ssrs report?

401

---

List all types of constraints in sql server?

1009

---

What are the differences between clustered and non-clustered index?

1021

---

How to insert stored procedure result into temporary table?

1011

---

What is the meaning of resultset type_scroll_insensitive?

950

---

What is instead of dml trigger?

995

---

What is query cost in sql server?

987

---

How to list all user defined functions in the current database?

1035

---

What is the difference function and stored procedure?

1047

---

Give the query of getting last two records from the table in SQL SERVER?

947

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1036

---

Can you explain full-text query in sql server?

1004

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1143

---

What is lookup override?

1019

---

Would you store your query in a ssrs report or a database server? State the reason why?

152

---