What are the types of subquery?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

Which are ddl commands?

0 Answers  

---

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

---

---

Can you index views?

0 Answers  

---

Explain few examples of RDBMS?

0 Answers   Wipro,

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Do you know what is rank function?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---