CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS
Question :
What is the difference between Varchar and Varchar2?
Category SQL Server Interview Questions
Rating (2.3) By 3 users
Added on 4/3/2008
Views 787
Rate it!
Answers:

varchar2: used for variable length character string ..stores the value on the disk

varchar: exactly same as varchar2 the difference is that it doesnt store the value since it hav to be retrieved for further use

char: char is used for fixed length character string..





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
What is the difference between Inner join and full outer join in terms of the Number of rows return
View Answer
What is table in SQL server? What is ##table in SQL server?
View Answer
Give some examples of Analytical functions?
View Answer
What is the difference between "translate" and "replace"?
View Answer
How functional dependency is related to database table design?
View Answer
What is DYNAMIC SQL method ?
View Answer
What is the query used to display all tables names in SQL Server (Query analyzer)?
View Answer
What is the query used to display all tables names in SQL Server (Query analyzer)?
View Answer
What is a dirty page and dirty report?
View Answer
What are the new enhancements in SQL server 2005?
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL SQL Server Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/14974/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

1.19