Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What do you understand by the data quality services in sql server?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

What is sleeping status in sql server?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---