Invoke Stored Procedure Using T-SQL

Listing 5. Once you deploy the stored procedure, you can execute it from other .NET code using an ADO.NET Command object, or even invoke it entirely through T-SQL.

declare @host varchar(512)
set @host = '207.68.188.118'

declare @return_status int

execute @return_status = dbo.SP_OutputParamDemo 'log this text', @host OUTPUT

print @host
print @return_status