SQL image data type

30 pts.
Tags:
.NET development
SQL development
Hello expert, I have a developer using .NET front end then call function with image data type to load data into #temp table. He said that will be easy. I need help with few questions. 1. Using image, xml and ntext, will those data type effect performance. 2. If I do not want to use those data type, what is alternative?

Answer Wiki

Thanks. We'll let you know when a new response is added.

The image, text and ntext data types shouldn’t be used any more as they will be removed in a future version of SQL Server. If you are storing binary data you should be using the varbinary(max) data type. If you are storing text data you should be using the varchar(max) or nvarchar(max) data types. If you are storing XML documents you should be using the XML data type.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following