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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Select from following answers:

Tinyint
smallint
int
float
All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : You are working with a DataSet and want to be able ...

Next > : What is the name of store procedure to send Email ...

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

More Interview Questions by Lakhangarg

What is the name of store procedure to send Email using SQL Server 200 ...
Query to Get List of Views?
Query to Select n Rendom Records From a Table in the Database?
Query To Get The Column Name,DataType, And Length of columns in a Tabl ...
How we can Get List of Triggers?
Query to Get List of Table Valued Functions?
How We Can Get List of Scalar Functions?
How We can Get List of Store Procedures?

Latest Interview Questions

Can you nest UpdatePanel within each other?
What are the different code models available in ASP.NET 2.0?
Can the App_Code folder contain source code files in different program ...
Can I use different programming languages in the same application?
How can you detect if a viewstate has been tampered?
You catch an unhandled exception in a Page_Error handler. How can you ...
ViewState is encrypted.
Does SessionID change with every request in the asp.net 2.0 applicatio ...
More ...