Answer Posted / samar

plz explain in brief,

if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com

How do I make a resultset scrollable?

942

---

what is isolation level at dead lock?

2134

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1086

---

What are trace flags and mention a few common trace flags used with sql server?

1072

---

What is the difference between Triggers and Stored Procedure?

1083

---

What does truncate do?

924

---

What are different types of statements that are supported by sql?

1024

---

What are ddl triggers and types of ddl trigger?

1017

---

How to create an index on a view?

1049

---

What is set nocount on and what is set nocount off?

928

---

Can a table have 2 primary keys?

971

---

Do you know clustered and non-clustered index?

965

---

Explain logical operators in sql server?

1093

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1036

---

Explain the difference between primary keys and foreign keys?

1006

---