What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

what is a stored procedure and trigger?

3 Answers  

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

What is lock escalation? : sql server database administration

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

Explain what are the authentication modes in sql server?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---