关于存储过程,大家来看看!!!
我的数据库有一个datetime字段,允许为空.我用存储过程来Insert这个表.但存储过程非要提供这个datetime字段的值,我该怎么做才能让它为null呢?
我的存储过程,@FlightReDate为此datetime字段
CREATE PROCEDURE sp_CheckOrder_CreateOrder
@OrderID int,
@TicketCode varchar(4),
@UserID int,
@UserName varchar(8),
@UserPhone varchar(14),
@EmailAddress varchar(100),
@Address varchar(150),
@EspecialRequest varchar(255),
@FlightDeID varchar(6),
@FlightReID varchar(6),
@FlightDeDate SmallDateTime,
@FlightReDate SmallDateTime,
@SumPayment SmallMoney,
@OrderDate SmallDateTime
AS
INSERT INTO OrderList(OrderID,TicketCode,UserID,UserName,UserPhone,EmailAddress,Address,EspecialRequest,FlightDeID,FlightReID,FlightDeDate,FlightReDate,SumPayment,OrderDate)
VALUES(@OrderID,@TicketCode,@UserID,@UserName,@UserPhone,@EmailAddress,@Address,@EspecialRequest,@FlightDeID,@FlightReID,@FlightDeDate,@FlightReDate,@SumPayment,@OrderDate)