What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

How to disable triggers using "disable trigger"?

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

Define indexes?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

How to get nth highest salary from employee table.

0 Answers  

---