语法: WRITETEXT { table.column text_ptr } [ WITH LOG ] { data } 将insert语句改为writetext语句 试试, myCom.CommandText="writetext table.column @data"; myCom.Parameters.Add("@data",yourdata); myCom.ExceteNoneQuery();不过我没有试过,希望对你有点帮助.
if your data is that big, the following article might not help you: HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual C# http://support.microsoft.com/default.aspx?scid=kb;en-US;Q309158
WRITETEXT { table.column text_ptr } [ WITH LOG ] { data } 是sqlserverl里面的用法,不知道在.net里面能不能用:(按saucer(思归)的做吧
100多列还不一样添加
insert语句可以让用户插入小于8000个字节的数据,如果所要查插入的文字或图像数据超过8000个字符时,就不能使用insert语句,此时就必须用writetex、readtext以及updatetext等语句才可以将大于8000个字节的数据写入到表格中!
比如在.net中如何应用?
WRITETEXT { table.column text_ptr }
[ WITH LOG ] { data }
将insert语句改为writetext语句
试试,
myCom.CommandText="writetext table.column @data";
myCom.Parameters.Add("@data",yourdata);
myCom.ExceteNoneQuery();不过我没有试过,希望对你有点帮助.
HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual C#
http://support.microsoft.com/default.aspx?scid=kb;en-US;Q309158
[ WITH LOG ] { data }
是sqlserverl里面的用法,不知道在.net里面能不能用:(按saucer(思归)的做吧