What are the purposes and advantages stored procedure?

0 Answers  

---

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

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Explain the usage of floor function in sql server.

0 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

How to change server name in sql server?

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

Define synonym?

0 Answers  

---