CREATE PROCEDURE dbo.proc_AccountCategorySelectCommand
AS
SET NOCOUNT ON;
SELECT
AccountCategoryID,
IsAvailable,
AccountCategory
FROM
AccountCategory
;
AS
SET NOCOUNT ON;
SELECT
AccountCategoryID,
IsAvailable,
AccountCategory
FROM
AccountCategory
;
CREATE PROCEDURE AllRooms
AS
select * from Rooms--添加记录
CREATE PROCEDURE AddRoom
@Room varchar(16),
@isdel bit
AS
declare @count int
select @count=count(ID) from Rooms where Room = @Room
if @count=0
insert into Rooms(Room) values(@Room)
return @@IDENTITY