What is Index Segmentation ?

1 Answers   TCS,

---

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,

---

How make remote connection in database?

1 Answers  

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---

Explain the commands in sql server?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---