Shulou(Shulou.com)05/31 Report--

This article shows you what the input and output parameters are in the stored procedure in Sql Server. The content is concise and easy to understand, which can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

[sql]

-- [create stored procedure]

USE [Message] GO / * Object: StoredProcedure [dbo]. [read external database query] Script Date: 10Accord 24Universe 05:39:16 * / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO--

\\ Working does not change 1, error code does not test, schedule time test, enterprise name create PROCEDURE [dbo]. [database query] @ SmsContent varchar (20) = '1231'

-- enter parameter @ bj1 int out

-- input parameter AS BEGIN SELECT @ bj1=count (Id) from sss END--

[call]

USE [Message] DECLARE @ return_value int EXEC [dbo]. [database query] '1231 database output SELECT @ return_value

The above is what are the input and output parameters of stored procedures in Sql Server. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.