Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8143 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopa
with double-pipes (SET price=0 || status = 'I')
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
Can we create clustered index without primary key?
How does one load ebcdic data? : aql loader
What is a sql statement?
what is the use of double ampersand (&&) in sql queries?
How many types of tables are there?
What are different types of sql commands?
What is primary key and unique key?
How many types of index are there?
Will truncate release space?
Can we rollback after truncate?
What is the cause of mutating table error and how can we solve it?
is mysql query is case sensitive? : Sql dba
What is the difference between union and union all command?
How does postgresql compare to "nosql"?
What is localdb mssqllocaldb?
