Answer Posted / bhupesh

Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.

What is indexed view? How to create it?

1007

---

What structure can you implement for the database to speed up table reads?

1199

---

What is tempdb in sql server?

972

---

explain declarative management framework (dmf) in sql server 2008?

991

---

List out a number of the wants to setup a SQL Server failover cluster?

1073

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1075

---

How do I port a number to sql server?

1038

---

What are the differences between substr and charindex in sql server.

1113

---

What is the difference between a function and a stored procedure?

1070

---

Where are stored procedures in sql server?

1065

---

What is the web service used for reporting services?

123

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

975

---

Do you know nested transaction?

958

---

What are page splits?

995

---

How can you list all the table constraints in a database?

938

---