基本存储过程应用

来源：互联网发布：jdk1.8 linux 64 下载编辑：程序博客网时间：2024/05/17 03:23

基本添加、修改、删除的存储过程
＝＝＝＝＝＝＝＝＝添加＝＝＝＝＝＝＝＝＝＝

ALTER PROCEDURE [GuestRoomAdd]
(@RID [varchar](50),
@RType [int],
@RPosition [varchar](50),
@RDescribe [varchar](50))

AS INSERT INTO [HMS].[dbo].[GuestRoom]
( [RID],
[RType],
[RPosition],
[RDescribe])

VALUES
( @RID,
@RType,
@RPosition,
@RDescribe)

＝＝＝＝＝＝＝＝＝修改＝＝＝＝＝＝＝＝＝＝

ALTER PROCEDURE [GuestRoomModify]
(@RID [varchar](50),
@RType [int],
@RPosition [varchar](50),
@RDescribe [varchar](50))

AS UPDATE [HMS].[dbo].[GuestRoom]

SET [RType] = @RType,
[RPosition] = @RPosition,
[RDescribe] = @RDescribe

WHERE
( [RID] = @RID)

＝＝＝＝＝＝＝＝＝删除＝＝＝＝＝＝＝＝＝＝＝

ALTER PROCEDURE [GuestRoomDelete]
(@RID [varchar](50))

AS DELETE [HMS].[dbo].[GuestRoom]

WHERE
( [RID] = @RID)

＝＝＝＝＝＝＝查看详细信息＝＝＝＝＝＝＝＝＝

ALTER PROCEDURE [GuestRoomDetail]
  @RID VARCHAR(50)
AS SELECT   [dbo].[RoomType].[TID],
   [dbo].[RoomType].[TName],
   [dbo].[RoomType].[TPrice],
   [dbo].[GuestRoom].[RID],
   [dbo].[GuestRoom].[RType],
   [dbo].[GuestRoom].[RPosition],
   [dbo].[GuestRoom].[RDescribe]
FROM    [dbo].[RoomType],
   [dbo].[GuestRoom]
WHERE   GuestRoom.RType=RoomType.TID
   AND GuestRoom.RID=@RID

＝＝＝＝＝＝＝＝显示列表＝＝＝＝＝＝＝＝＝＝＝＝＝

ALTER PROCEDURE [GuestRoomList]
AS SELECT   [dbo].[RoomType].[TID],
   [dbo].[RoomType].[TName],
   [dbo].[RoomType].[TPrice],
   [dbo].[GuestRoom].[RID],
   [dbo].[GuestRoom].[RType],
   [dbo].[GuestRoom].[RPosition],
   [dbo].[GuestRoom].[RDescribe]
FROM    [dbo].[RoomType],
   [dbo].[GuestRoom]
WHERE   GuestRoom.RType=RoomType.TID
ORDER BY TID DESC