What is the difference between left and right outer join?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

How is table type constraint applied to a table?

0 Answers  

---

How many null values we can have in a unique key field in sql server?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What is the most common trace flags used with sql server?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---

Can we insert data if clustered index is disabled?

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,

---