CATEGORIES
what is the difference between Text and String Data type in SQL Server
Published by: Rinku (10/25/2008 1:10:19 AM)
OCT 25 2008
I dont really understand the major differences between a STRING Data type and Text Data type in SQL Server. Most operations that can be done with strings can be done with text data type too. Can anyone advise practically where to use a string data type and where to use Text data type. Which of them is better for performance issues.
Most Popular Articles
- SQL Server 2008 Error: is not a valid login or you do not have permission
- Cannot start .aspx
- what is the difference between Text and String Data type in SQL Server
- Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- Why my MS SQL Server 2005 DSN Connection is not Working
Can I Update 2 Tables Using Single SQL Query >>
<< Can I Run SQL Server 2000 and SQL Server 2005 at the Same Time
COMMENT
Name: Cornflake
Me too. I need to develop a script to search in the txt database (I don’t want to use MySQl) and I’d like to know if it’s good way to go.
---------------------------------------------------
Free iPhone
Name: Java
<div style="width:100%;height:50px;font-size:50px;font-family:Georgia;filter:glow(color=’#aaccff’,strength=’45’);color:white;">Text and String</div>
What is the Difference Between <b>Text</b> and <b>String</b>.............??