Z
zhengyue
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE PROCEDURE [rkdadd]
(@date smalldatetime ,@khbh char(10),
@khmc varchar(30),@jbr char(4),@dwywy varchar(10),@zd char(4),
@rkdnum int output)
AS
insert rkd (date,khbh,khmc,jbr,zd) values (@date,@khbh,@khmc,@jbr,@zd)
select @rkdnum=max(rkdnum) from rkd
请问各位:
怎样为@date 赋默认的当天的日期
(@date smalldatetime ,@khbh char(10),
@khmc varchar(30),@jbr char(4),@dwywy varchar(10),@zd char(4),
@rkdnum int output)
AS
insert rkd (date,khbh,khmc,jbr,zd) values (@date,@khbh,@khmc,@jbr,@zd)
select @rkdnum=max(rkdnum) from rkd
请问各位:
怎样为@date 赋默认的当天的日期