存储过程EXEC带参数输出

CREATE PROCEDURE [dbo].[sp_IXC2_BuindupFunction_GetIsShare]

       -- Add the parameters for the stored procedure here

       @strWhere VARCHAR(400),

       @metaInfo VARCHAR(20)    output                  

AS

BEGIN

       -- SET NOCOUNT ON added to prevent extra result sets from

       -- interfering with SELECT statements.

       DECLARE @strSQL NVARCHAR(4000)

       SET @strSQL = N'SELECT @metaInfo=[MetaInfo]   FROM vi_IXC2_BuildupFunction_Share'

       IF @strWhere<>''

       BEGIN

              SET @strSQL = @strSQL+N' WHERE '+ @strWhere

       END

      

       EXEC SP_EXECUTESQL @strSQL,N'@metaInfo VARCHAR(20) OUTPUT',@metaInfo OUTPUT

END