how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

How do I delete a sql server database?

0 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

---

How to get the definition of a user defined function back?

0 Answers  

---

What do you understand by user-defined function in the sql server?

0 Answers  

---

What are database states in ms sql server?

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,

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

What is an sql server agent?

0 Answers  

---