Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is sql query optimization?

1051


How sql query is executed?

1086


Why schema is used in sql?

1003


What is scalar and vector?

957


What is the difference between left outer join and left join?

962


Explain constraints in sql?

1002


Which language is used in sql?

1012


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

1263


What is oracle sql developer?

1006


What is a recursive stored procedure?

1120


When to use inner join and left join?

924


What is delete command in sql?

1066


Why stored procedures are faster than query?

989


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

1004


what are all the different normalizations? : Sql dba

985