Wire-Up SQL Server to the Method in the Assembly

Listing 6. As with the scalar function, if you are manually importing the assembly into the database using SQL Server Management Studio, you also need to manually execute a CREATE PROCEDURE statement to explicitly wire-up SQL Server to the method in the assembly.

CREATE PROCEDURE [dbo].[SP_OutputParamDemo]
	@msg [nvarchar](4000),
	@Address [nvarchar](4000) OUTPUT
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [SqlclrDemo].[StoredProcedures].[OutputParamDemo]