Max length allowed for RETURN in a function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Max length allowed for RETURN in a function

Max length allowed for RETURN in a function

Rate Topic

Display Mode

Topic Options

Author

Message

_UB

Posted Tuesday, August 05, 2008 5:16 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 295, Visits: 396

ALTER FUNCTION dbo.Translate (@Source VARCHAR(8000))
RETURNS VARCHAR(8000)
AS
BEGIN
-- do something
-- do more
--
-- at last

RETURN REPLICATE('a', 8000)
END

/*
TESTING:
SELECT dbo.Translate('blah')

Output:
aaaaaaaaaa..... 256 times
*/

Output value has length of 256, even though REPLICATE 8000 is used..... why? I am I missing something. Please help.

SqlTimes Blog on Sql Server

Post #547180

_UB

Posted Tuesday, August 05, 2008 6:09 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 295, Visits: 396

oops..!!

The problem is not with the function, but with my SSMS. The default value for column length is set to 256.

SqlTimes Blog on Sql Server

Post #547193

« Prev Topic | Next Topic »

Permissions