How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

What is a trigger?

7 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

List all the types of user-defined functions?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What is the use of stored procedure?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

what's the maximum size of a row? : Sql server database administration

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---