RSS feed

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.

 

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>.............??

*Name:
*Comment:
You can use HTML tags here.
*Code: Please enter the sum of 5+2