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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is meant by deafult in sql server?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is meant by deafult in sql server? ..

Answer / s. elaiyaraja

Default is the column value used in the sql.

if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.

For example varchar columns are defined as null value for
default value.

Is This Answer Correct ?    3 Yes 0 No

what is meant by deafult in sql server? ..

Answer / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

How do you check sql server is up and running?

0 Answers  

What is indexing?

0 Answers   AOL,

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

How to view the error log for any specific instance? : sql server database administration

0 Answers  

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

What is the purpose of forms?

0 Answers  

What are indexers?

0 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

Can we write ddl in trigger?

0 Answers  

What is analysis service repository?

0 Answers  

What is candidate key with example?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories