SQL image data type
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 18, 2009 2:12 PM
UPDATED:
June 19, 2009 8:12 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
