I need to Add one column in a existing table and the max value of the column can be 10, which data type i need to use for that?

 Posted by Lakhangarg on 9/29/2009 | Category: Sql Server Interview questions | Views: 12253
Select from following answers:
  1. Tinyint
  2. smallint
  3. int
  4. float
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Pandians on: 9/29/2009

Pl remove the SPACE between the DataTypes' Name, This is syntatically wrong.

Use TinyInt insteadof Tiny int
Use SmallInt insteadof small int


Posted by: Lakhangarg on: 9/29/2009
Thanks Pandians for pointing out my mistake..

Login to post response