What are the security related catalog views? : sql server security

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What is unpivot?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

What is self contained sub query?

0 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---