What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

How do I completely remove sql server instance?

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,

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

What is difference between oltp and olap?

0 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

What is bcp? When does it use?

0 Answers  

---