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 / 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


Please Help Members By Posting Answers For Below Questions

Explain the difference between sql and mysql.

1000


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976


What is dcl in sql?

903


What are local and global Indexes and where they are useful.

1377


Why is normalization important?

967


What is scalar and vector?

929


What are all the ddl commands?

1112


How do I view stored procedures?

912


What is the purpose of the sql select top clause?

1016


what is the difference between nested subquery and correlated subquery?

979


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007


Does sql backup shrink transaction log?

911


What do you understand by pl/sql cursors?

1011


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

952


How to rename a table?

953