Problem in Execution - SQL Server Forums

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)

Problem in Execution

Author

Topic

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-06-04 : 08:33:27

Dear gurus,

I created a CLR integration for Reversing the String
for eg: I/P: Check
O/p: kcehC

But my SP returns :'Command(s) completed successfully.'
My Clr integration coding is below,Plz help me...,

CREATE ASSEMBLY DotNetFunSQLServerSProc
FROM 'D:\SQLMyNameRev.dll'
WITH PERMISSION_SET = UNSAFE

GO
create PROC NameRevMethod (@val nvarchar(32))
AS
EXTERNAL NAME DotNetFunSQLServerSProc.[SQLMyNameRev.NameReverse].NameRevMethod
GO

exec NameRevMethod 'Check'

cool...,

Zack
Starting Member

26 Posts

Posted - 2008-06-05 : 07:45:15

There's a bug in your function as documented above. I/P: Check should return kcehC :P/I :). What would help is if you would post the code for the CLR method you've created.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources