SQL存储过程示例-优快云博客

本文链接：https://blog.youkuaiyun.com/ITX2000/article/details/8977898

本文介绍了几个SQL存储过程示例，包括添加用户信息到数据库、显示特定数据以及将信息插入到第三个表中等操作。这些示例展示了如何使用T-SQL进行数据库管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ALTER proc [dbo].[Addkeyuser]
@keyusername nvarchar(50),
@planname nvarchar(50),
@typeid int
as
declare @keyusernumber nvarchar(50),@ordersn int,@planid int
select @keyusernumber=KEYUSERNUMBER,@ordersn=ORDERSN,@planid=PLANID from [KEYUSER],[PLANTYPE],[PLAN] WhereKEYUSERNAME=@keyusername andPLANNAME=@planname and [PLAN].TYPEID=@typeid
insert into KEYUSERMANAGE(ORDERSN,PLANID,KEYUSERNUMBER) values(@ordersn,@planid,@keyusernumber)

查找的存储过程

ALTER proc [dbo].[DisPlay]
as
SELECT [PLANTYPE].[DESCRIPTION] from [PLAN],[PLANTYPE] where [PLAN].TYPEID=[PLANTYPE].TYPEID
select KEYGROUPNUMBER from [KEYGROUPMANAGE] left join [PLANTYPE] ON [KEYGROUPMANAGE].ORDERSN=[PLANTYPE].ORDERSN
select PLANNAME from [PLAN] ,[PLANTYPE]where [PLAN].TYPEID=[PLANTYPE].TYPEID
select KEYUSERNUMBER from [KEYUSERMANAGE] left join [PLANTYPE] on [KEYUSERMANAGE].ORDERSN=[PLANTYPE].ORDERSN
Select ITSERVERNUMBER FROM [ITSERVERMANAGE] left join [PLAN] ON [ITSERVERMANAGE].PLANID=[PLAN].PLANID
go

插入第三个表中

as
declare @DESCRIPTION nvarchar(50),@KEYGROUPNUMBER nvarchar(50),@PLANNAME nvarchar(50),@KEYUSERNUMBER nvarchar(50),@ITSERVERNUMBER nvarchar(50)
SELECT @DESCRIPTION=[PLANTYPE].[DESCRIPTION] from [PLAN],[PLANTYPE] where [PLAN].TYPEID=[PLANTYPE].TYPEID
select @KEYGROUPNUMBER=KEYGROUPNUMBER from [KEYGROUPMANAGE] left join [PLANTYPE] ON [KEYGROUPMANAGE].ORDERSN=[PLANTYPE].ORDERSN
select @PLANNAME=PLANNAME from [PLAN] ,[PLANTYPE]where [PLAN].TYPEID=[PLANTYPE].TYPEID
select @KEYUSERNUMBER=KEYUSERNUMBER from [KEYUSERMANAGE] left join [PLANTYPE] on [KEYUSERMANAGE].ORDERSN=[PLANTYPE].ORDERSN
Select @ITSERVERNUMBER=ITSERVERNUMBER FROM [ITSERVERMANAGE] left join [PLAN] ON [ITSERVERMANAGE].PLANID=[PLAN].PLANID
insert into AUTHORITY ([DESCRIPTION],KEYGROUPNUMBER,PLANNAME,KEYUSERNUMBER,ITSERVERNUMBER) values (@DESCRIPTION,@KEYGROUPNUMBER,@PLANNAME,@KEYUSERNUMBER,@ITSERVERNUMBER)
go

http://www.cnblogs.com/goody9807/archive/2010/10/22/1858256.html

增删