How to test subquery results with the exists operator?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

Do you know the cursor types?

0 Answers  

---

Explain steps of normalization?

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 is a partition function in sql server?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---

What are different types of views?

0 Answers  

---

What are acid properties of transaction?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---