if we give update table_name set column_name= default.
what will happen?
Answer Posted / meher
If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql query optimization?
How sql query is executed?
Why schema is used in sql?
What is scalar and vector?
What is the difference between left outer join and left join?
Explain constraints in sql?
Which language is used in sql?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is oracle sql developer?
What is a recursive stored procedure?
When to use inner join and left join?
What is delete command in sql?
Why stored procedures are faster than query?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what are all the different normalizations? : Sql dba