Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Error Message

Author  Topic 

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-06-04 : 10:13:46

I'm getting this error while creating a function for clr integration..



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

PLZ help me..,
Thanks in advance..,

cool...,

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-04 : 23:15:30
How to help without looking at code?
Go to Top of Page

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-06-05 : 02:47:30
create FUNCTION F_NameRevMethod
(
@name nvarchar(1000)
)
RETURNS nvarchar(max)
AS EXTERNAL NAME DotNetFunSQLServerSProc.[SQLMyNameRev.NameReverse].NameRevMethod


cool...,
Go to Top of Page

Zack
Starting Member

26 Posts

Posted - 2008-06-05 : 07:42:43
What type of value is the CLR SP attempting to return?
Go to Top of Page
   

- Advertisement -