Answer / jerry joseph

Static query will be executed as it is.

Dynamic query is built upon conditions depending upon the
parameters.

Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

How do triggers work?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

What is inline table-value user-defined function?

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---