Sql Server中存储过程中输入和输出参数(简单实例 一看就懂)

Question

如题所述

Answer 1

[sql]
--
===================【创建存储过程】=====================
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