Code demonstration of input and output parameters in stored procedures in SQL Server

From , 3 Years ago, written in SQL, viewed 140 times.

-- ===================【创建存储过程】=====================
 
USE [Message]
GO
/****** Object:  StoredProcedure [dbo].[读取外部数据库查询]    Script Date: 10/24/2012 05:39:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================  \\ Working没有变1，错误码没有测试,计划时间测试,企业名称
 
CREATE PROCEDURE [dbo].[数据库查询] 
        @SmsContent VARCHAR(20)='1231',   -- 输入参数
        @bj1 INT OUT -- 输入出参数
         
AS
BEGIN
             
    SELECT @bj1=COUNT(Id) FROM sss
    
END
 
 
-- ===============【调用】==================
 
USE [Message]
 
DECLARE @return_value INT
 
EXEC    [dbo].[数据库查询] '1231',@return_value output
 
SELECT  @return_value
//SQL/5542

Reply to "Code demonstration of input and output parameters in stored procedures in SQL Server"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters

https://burned.cc - Burn After Reading Website

Pastebin.vip

Code demonstration of input and output parameters in stored procedures in SQL Server

Reply to "Code demonstration of input and output parameters in stored procedures in SQL Server"