C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

Data Types


Posted Date: 03 Nov 2009      Posted By: Sameer Sayani      Member Level: Gold     Points: 1   Responses: 2



What are the new data types introduced in SQL-2005 and What are there features?




Responses

Author: Manick    03 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

In SQL server 2005..

Varchar(max) – It will allow us to use sequence of characters greater than 8000 bytes (8000 characters). The maximum size is 2GB.

nVarchar(max) - It will allow us to use sequence of characters greater than 8000 bytes (4000 characters). The maximum size is 2GB.

VarBinary(max) - It will allow us to use binary data greater than 8000 bytes.

Regards,
Manick



Author: Tamil Maran    03 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

Refer This

http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html

Thz
Jagadish.J



Post Reply
You must Sign In to post a response.
Next : Views
Previous : What is the difference between sql and plsql?Explain?
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use