What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

Difference between report and query parameter.

0 Answers  

---

How many cores do I need for sql server 2016?

0 Answers  

---

How to disable stored procedure sql server?

0 Answers  

---

Will the writetext statement activate a trigger?

0 Answers  

---

---

Why use cursor in sql server?

0 Answers  

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

What is the order in which the sql query is executed?

0 Answers  

---

what is memory-optimized nonclustered indexes

0 Answers  

---

What is the recovery model?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

How to create an index on a view?

0 Answers  

---