What are different types of data sources?

0 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

Do you know what is rank function?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

which table keeps the locking information? : Sql server administration

0 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,

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

Explain go command in sql server?

0 Answers  

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

Explain unique key in sql server?

0 Answers  

---