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: 14864
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
Hi

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

Use TinyInt insteadof Tiny int
Use SmallInt insteadof small int

Cheers

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

Login to post response