Execute a stored procedure/create a stored procedure:

Use [ao08]
Go

Declare @ return_value int

Exec @ return_value = [DBO]. [sp_insert_sys_msg]
@ Type = n'2 ',
@ MSG = n'abc ',
@ Msg_from = n 'zhangshan ',
@ Msg_to = n'000000'

Select 'Return value' = @ return_value

Go

Create a stored procedure: Set ansi_nulls on
Set quoted_identifier on
Go

-- ===================================================== ======
-- Author: <author, Name>
-- Create Date: <create date,>
-- Description: <description,>
-- ===================================================== ======
Alter procedure [DBO]. [sp_insert_sys_msg]
-- Add the parameters for the stored procedure here
@ Type varchar (20), -- Variable
@ MSG varchar (20), -- Chinese Character content
@ Msg_from varchar (20), -- Chinese name
@ Msg_to varchar (20 )--


As
Begin
-- Set nocount on added to prevent extra result sets from
-- Interfering with select statements.
Set nocount on;
Declare @ susercode varchar (50 );
Select @ susercode = '';
Select @ susercode = user_code from pd_user where [user_name] = @ msg_from;
-- Insert statements for procedure here

Insert into sys_msg ([type], MSG, msg_from, msg_to)
Values (@ type, @ MSG, @ susercode, @ msg_to)

End