SQL image data type
Home > IT Answers > Development > SQL image data type
Maylee63
30 pts.
0
Q:
SQL image data type
SQL development, .NET 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?
ASKED: Jun 18 2009  2:13 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jun 19 2009  8:12 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0