Answer / dileep

Use OPENROWSET

What is the use of keyword with encryption.

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Is resultset an interface?

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

What is log shipping?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

What is self join in sql server joins?

0 Answers  

---

Explain partitioned view?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---