What will be the maximum number of indexes per table?

0 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

Why use “pivot” in sql server?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

What is 3nf normalization form?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

What is Replication?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

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,

---