-
执行存储过程 /创建存储过程:
USE [AO08]
GO
![](/Images/OutliningIndicators/None.gif)
DECLARE @return_value int
![](/Images/OutliningIndicators/None.gif)
EXEC @return_value = [dbo].[sp_insert_sys_msg]
@type = N'2',
@msg = N'abc',
@msg_from = N'张山',
@msg_to = N'0003'
![](/Images/OutliningIndicators/None.gif)
SELECT 'Return Value' = @return_value
![](/Images/OutliningIndicators/None.gif)
GO
创建存储过程:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
![](/Images/OutliningIndicators/None.gif)
-- =============================================
-- 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),--变量
@msg varchar(20),--汉字内容
@msg_from varchar(20),--汉字姓名
@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)
![](/Images/OutliningIndicators/None.gif)
END
![](/Images/OutliningIndicators/None.gif)
-
相关阅读:
[导入]【翻译】WF从入门到精通(第十三章):打造自定义活动
[导入]关于网页标准与JAVAScript执行的问题
html包含html文件的方法
[导入]C#加密方法汇总
8、步步为营VS 2008 + .NET 3.5(8) DLINQ(LINQ to SQL)之面向对象的添加、查询、更新和删除
[导入]【翻译】WF从入门到精通(第十五章):工作流和事务
[导入]存储过程得到某个表的所有字段信息
1、步步为营VS 2008 + .NET 3.5(1) VS 2008新特性之Multi Targeting(多定向)、Web Designer and CSS(集成了CSS的web设计器)和Nested Master Page(嵌套母版页)
[导入]vbs修改注册表
正则表达式30分钟入门教程
-
原文地址:https://www.cnblogs.com/simhare/p/926981.html
Copyright © 2020-2023
润新知