Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

---

How to test a dml trigger in ms sql server?

0 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---

Explain what is public role in sql server?

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

How to access the deleted record of an event?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Why is normalisation important?

0 Answers  

---