How to PRINT a message from SQL CLR function?
The answer is that you cannot do the equivalent of PRINT ‘Hello World’ from inside a [SqlFunction()]. You can do it however from a [SqlProcedure()] using SqlContext.Pipe.Send(“hello world”) This is consistent with T-SQL, where you would get the error “Invalid use of a side-effecting operator ‘PRINT’ within a function” if you stick a PRINT inside … Read more