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  

---

How do I truncate a word?

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is sqlcommand?

0 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

What is difference between stored procedure and trigger?

0 Answers  

---

Can we use ddl statements in stored procedure sql server?

0 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---

What is natural join in sql?

0 Answers  

---

Is sql port 1433 encrypted?

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---