Answer / Hemant S Budiyal

SQL Server is a relational database management system developed by Microsoft, and ASE (Advanced Server Edition) is an older version of SQL Server that supports multiple instances on a single server.

What is function and procedure?

1 Answers  

---

What is union and union all keyword in sql and what are their differences?

1 Answers  

---

What is indexing in sql and its types?

1 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

What is online transaction processing (oltp)?

1 Answers  

---

What are triggers and its uses?

1 Answers  

---

What is sql prepared statement?

1 Answers  

---

What is a primary key? Explain

1 Answers  

---

What is a join query?

1 Answers  

---

What is data type in sql?

1 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---