What are various limitations of the views?

0 Answers  

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

---

What is the command used to get the version of sql server?

1 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

What is function of CUBE ?

0 Answers   HCL,

---

Differentiate between a having clause and a where clause.

0 Answers  

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---