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
- 9926 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
How to get help at the sql prompt?
Is primary key clustered or nonclustered?
what is sub-query? : Transact sql
How do I remove all records from a table?
how to see the create table statement of an existing table? : Sql dba
What is the difference between row level and statement level trigger?
What are the properties of a transaction?
Why we use join in sql?
How much does sql cost?
Write a sql query to find the names of employees that begin with ‘a’?
what is a record in a database ? : Sql dba
What is pl sql collection?
How do I order columns in sql?
What is a stored procedure in sql with example?
Why primary key is required?
