CLR and return value types

• Alen Cappelletti

  Ten Centuries

  Points: 1172

  More actions

  July 21, 2008 at 10:43 am

  #191374

  I made an CLR using C# that return a string (> 8000 char).

  Now I try to register assembly into sql server 2005 but got an error...

  Msg 6551, Level 16, State 2, Procedure ABCD, Line 2

  CREATE FUNCTION for "ABCD" failed because T-SQL and CLR types for return value do not match.

  This the function

  -------------------

  CREATE FUNCTION ABCD(@body1 TEXT, @body2 TEXT)

  RETURNS NTEXT EXTERNAL NAME HTML1.HTML21.get

  Whet type I must use for rigth use.

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  July 21, 2008 at 11:14 am

  #845905

  Use nvarchar(max) instead of text.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]