05可以使用nvarchar(max) 这样就不会被截断了, 2k的话,只能调用针对Text处理的函数TEXTPTR/UPDATETEXT/WRITETEXT UPDATETEXT (Transact-SQL) http://technet.microsoft.com/zh-cn/library/ms189466.aspxUSE pubs; GO ALTER DATABASE pubs SET RECOVERY SIMPLE; GO DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(pr_info) FROM pub_info pr, publishers p WHERE p.pub_id = pr.pub_id AND p.pub_name = 'New Moon Books' UPDATETEXT pub_info.pr_info @ptrval 88 1 'b'; GO ALTER DATABASE pubs SET RECOVERY FULL; GO
会有text/ntext的专门处理方法TEXTPTR/UPDATETEXT/WRITETEXT
这样就不会被截断了,
2k的话,只能调用针对Text处理的函数TEXTPTR/UPDATETEXT/WRITETEXT
UPDATETEXT (Transact-SQL)
http://technet.microsoft.com/zh-cn/library/ms189466.aspxUSE pubs;
GO
ALTER DATABASE pubs SET RECOVERY SIMPLE;
GO
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(pr_info)
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
AND p.pub_name = 'New Moon Books'
UPDATETEXT pub_info.pr_info @ptrval 88 1 'b';
GO
ALTER DATABASE pubs SET RECOVERY FULL;
GO