How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Is it possible to update views?

0 Answers  

---

Is sql free?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

---

What are the different types of constraints?

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

Does execute immediate commit?

0 Answers  

---

What are the parts of a basic sql query?

0 Answers  

---

what is sql server agent? : Sql dba

0 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---