What is difference between sql function and stored procedure?

0 Answers  

---

What is the need of a partition key?

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

how many tupples can insert in 1 second in sql

1 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

---

What is dynamic query?

0 Answers  

---

Explain the insert into statements in sql?

0 Answers  

---