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

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

What is “asynchronous” communication in sql server service broker?

0 Answers  

What is a result set object returned by odbc_exec()?

0 Answers  

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

mention different types of relationships in the dbms?

0 Answers  

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

what is the maximum size of sql row in mssql?

1 Answers  

What is the importance of three tier architecture?

0 Answers   QuestPond,

What is the system function to get the current user's user id?

3 Answers   TCS,

What is the use of RDBMS?

0 Answers   Wipro,

What is application role in sql server database security? : sql server security

0 Answers  

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories