Different types of keys in SQL?

0 Answers   Infosys,

---

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,

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

How exceptions can be handled in sql server programming?

0 Answers  

---

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

How to delete duplicate rows?

0 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---