[email protected]@Price的值设为null插入数据库,请问下面代码会出错吗,如果会请问应该怎样修改呢?
CREATE PROCEDURE ST_InsertRoomCategory
(@Name varchar(50),@Area float,
@BedNum int, @Price money,
@AirCondition int,
@TV int)
AS
insert into ST_RoomCategory
( ST_Name,ST_Area,ST_BedNum,ST_Price,ST_AirCondition,ST_TV)
values
( @Name,@Area,@BedNum,@Price,@AirCondition,@TV)
GO
------解决方案--------------------
--try
CREATE PROCEDURE ST_InsertRoomCategory
(
@Name varchar(50)=null,
@Area float,
@BedNum int,
@Price money=null,
@AirCondition int,
@TV int
)
AS
insert into ST_RoomCategory
( ST_Name,ST_Area,ST_BedNum,ST_Price,ST_AirCondition,ST_TV)
values
( @Name,@Area,@BedNum,@Price,@AirCondition,@TV)
GO