What is Primary key and foreign key? Give an example

4 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 to enter comments in transact-sql statements?

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

What is a document index?

0 Answers  

---

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

What is the difference between rank and dense_rank?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

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

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---