USE a
GO
IF EXISTS(SELECT name FROM sysobjects
WHERE name = 'InsertMoneyType' AND type = 'P')
DROP PROCEDURE InsertMoneyType
GO
USE a
GO
CREATE PROCEDURE InsertMoneyType
@money_id varchar(3),
@money_name varchar(10),
@money_sname varchar(10),
@change_rate float,
@MaxMoney_id varchar(3) output
AS
select @MaxMoney_id = (max(money_id) + 1) from MoneyTypeinsert into MoneyType(money_id,money_name,money_sname,change_rate)
values(@MaxMoney_id,
@Money_name,
@Money_sname,
@Change_rate)
GO
GO
IF EXISTS(SELECT name FROM sysobjects
WHERE name = 'InsertMoneyType' AND type = 'P')
DROP PROCEDURE InsertMoneyType
GO
USE a
GO
CREATE PROCEDURE InsertMoneyType
@money_id varchar(3),
@money_name varchar(10),
@money_sname varchar(10),
@change_rate float,
@MaxMoney_id varchar(3) output
AS
select @MaxMoney_id = (max(money_id) + 1) from MoneyTypeinsert into MoneyType(money_id,money_name,money_sname,change_rate)
values(@MaxMoney_id,
@Money_name,
@Money_sname,
@Change_rate)
GO
@money_name varchar(10),
@money_sname varchar(10),
@change_rate float,
@MaxMoney_id varchar(3) output
AS
declare @money_id varchar(3)
select @MaxMoney_id=max(money_id)+1 from MoneyTypeinsert into MoneyType(money_id,money_name,money_sname,change_rate) values(@MaxMoney_id,@money_name,@Money_sname,@Change_rate)
GO
exec InsertMoneyType 输入参数
F5执行
exec InsertMoneyType 'aa','bb',324,@a outputselect @a