Input and Output Parameters in SQL Server Stored Procedures (simple instances can be understood at a Glance)

[SQL]
-- ============================= [Create a stored procedure] ====================== ======
USE [Message]
GO
/***** Object: StoredProcedure [dbo]. [read external database query] Script Date: 10/24/2012 05:39:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ===================================================== ========\\ Working is not changed to 1, error Code not tested, scheduled time tested, company name
Create PROCEDURE [dbo]. [database query]
@ SmsContent varchar (20) = '123', -- enter the Parameter
@ Bj1 int out -- Input and Output Parameters
AS
BEGIN
SELECT @ bj1 = count (Id) from sss
END
-- =================== [Call] ================================
USE [Message]
DECLARE @ return_value int
EXEC [dbo]. [database query] '000000', @ return_value output
SELECT @ return_value