[dba-SQLServer] Text column truncating

Robert L. Stewart rl_stewart at highstream.net
Thu Jan 18 12:59:24 CST 2007


All,

I am trying to get a text data field to update in SQL 2000
using a stored procedure.

CREATE PROCEDURE [dbo].[sp_SQL_addUpdate]

@SQLUpdate_By		nvarchar(25),
@SQLUpdate_DB		nvarchar(15),
@SQLUpdate_Object		nvarchar(50),
@SQLUpdate_Description	varchar(8000),
@SQLUpdate_Script	text,
@SQLUpdate_ID		int	OUT

AS

     DECLARE @ptrval binary(16)

	INSERT INTO dbo.tblSQLUpdates(
		SQLUpdate_By,
		SQLUpdate_DB,
		SQLUpdate_Object,
		SQLUpdate_Description
	)
	VALUES (
		@SQLUpdate_By,
		@SQLUpdate_DB,
		@SQLUpdate_Object,
		@SQLUpdate_Description
	)

	SELECT @SQLUpdate_ID = @@Identity
	
     SELECT @ptrval = TEXTPTR(SQLUpdate_Script)
         FROM dbo.tblSQLUpdates
         WHERE SQLUpdate_ID = @SQLUpdate_ID
     WRITETEXT tblSQLUpdates.SQLUpdate_ID @ptrval @SQLUpdate_Script


When writing the text back, I am getting a truncated value.
My guess is that it is around 8000 characters.  Anyone have
any insight into it?

Thanks,

Robert





More information about the dba-SQLServer mailing list