Interested to Buy Any Domain ? << Click Here >> for more details...
if we give update table_name set column_name= default.
what will happen?
- 4 Answers
- 9547 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / mano chinna
It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is procedure and function?
How to display the current date in sql?
what is sp_pkeys? : Transact sql
What is cursor in pl sql?
How to combine two stored procedures in sql?
What is the difference between database trigger and stored procedure?
which types of join is used in sql widely? : Sql dba
Which data dictionary views have the information on the triggers that are available in the database?
What is scalar data type in pl sql?
Explain the steps needed to create the scheduled job?
What is trigger types of trigger?
What is the difference between clustered and non-clustered index in sql?
What are sql injection vulnerabilities?
What is synchronized subquery?
What are the main features of cursor?
