Input and output parameters in stored procedures in SQL Server (simple example to read) _mssql

[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 did not change 1, error code did not test, scheduled time test, business name
Create PROCEDURE [dbo]. [Database query]
@SmsContent varchar (20) = ' 1231 ',--input parameters
@bj1 int out--Input parameters
As
BEGIN
SELECT @bj1 =count (Id) from SSS
End
--=============== "call" ==================
Use [message]
DECLARE @return_value int
EXEC [dbo]. [Database query] ' 1231 ', @return_value output
SELECT @return_value