Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Database Software
  6. / Microsoft SQL Server

by yangjian on July 10th, 2008

yangjian

Question

Help answer this question below.

About Microsoft SQL Server data type text?

Share:
Other

Answers. 1 helpful answer below.

  • by ksrover on September 18th, 2008

    ksrover

    The text datatype is actually set to be retired in future versions of SQL. But, as of v2005, it is still being used.

    Basically, it is a larger datatype that can hold 2,147,483,647 characters in a field. Although, varchar(max) can also hold that many characters as well.
    Text datatypes will be smaller to store than varchar(xxx) types, but this comes with a performance hit to the server.

    • Like
    • Report

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading About Microsoft SQL Server data type text?

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Sql server datatypes interview questions
How to use text datatype in mssql server
Read and write text data type in sql server
What sql datatype will embed a youtube video
Mssql datatypes text 2008

Answerbag

a Demand Media company