if you gave a default value for that column then it takes that default v

if we give update table_name set column_name= default.
what will happen?

Question Posted / akki julak

Answer Posted / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we use ddl statements in stored procedure sql server?

1063

how to shut down the server with 'mysqladmin'? : Sql dba

1051

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1048

How many functions are there in sql?

1095

What will you get by the cursor attribute sql%notfound?

1130

What operators deal with null?

1155

Is sql a dbms?

1062

How do you truncate?

955

Explain about various levels of constraint.

1000

What is coalesce sql?

1056

How do I run a script in sql developer?

999

How can you create an empty table from an existing table?

1128

Can we delete column in sql?

1174

How can I see all tables in sql?

1145

What is secondary key?

988