How many levels of sp nesting is possible?

0 Answers  

---

What is the maximum size of sql server database?

0 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What are logical database components? : SQL Server Architecture

0 Answers  

---

---

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

---

What is row_number function?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---