基本存储过程应用

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

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