调用储存过程插入日期的问题！

Question

create PROCEDURE userdefine_insert_equp_manual
@manual_no char(12),
@start_vaild_day  datetime
ASexec('insert into equp_manual(manual_no,start_vaild_day)
values ('+@manual_no+','+@start_vaild_day+')')

Answer 1

create table equp_manual(manual_no varchar(12),start_vaild_day datetime)
go
create PROCEDURE userdefine_insert_equp_manual
@manual_no char(12),
@start_vaild_day  datetime
ASexec('insert into equp_manual(manual_no,start_vaild_day)
values ('''+@manual_no+''','''+@start_vaild_day+''')')gouserdefine_insert_equp_manual 'asdf','2003-2-2'go
select * from equp_manual

Answer 2

create table equp_manual(manual_no varchar(12),start_vaild_day datetime)
go
create PROCEDURE userdefine_insert_equp_manual
@manual_no char(12),
@start_vaild_day  datetime
ASinsert into equp_manual(manual_no,start_vaild_day)
values (@manual_no,@start_vaild_day)gouserdefine_insert_equp_manual 'asdf','2003-2-2'go
select * from equp_manual----asdf         2003-02-02 00:00:00.000

Answer 3

create table equp_manual
(manual_no char(12),
start_vaild_day datetime
)
gocreate PROCEDURE userdefine_insert_equp_manual @manual_no char(12),
@start_vaild_day  datetime
as
insert into  equp_manual
         (manual_no,start_vaild_day)
values   (@manual_no,@start_vaild_day)go
exec userdefine_insert_equp_manual 'id1','2003-7-17'
exec userdefine_insert_equp_manual 'id2','2000.2.20'
exec userdefine_insert_equp_manual 'id3','1998-03-04 00:00:00.000'
go
select * from equp_manualresult:
manual_no    start_vaild_day                                        
------------ ------------------------------------------------------ 
id1          2003-07-17 00:00:00.000
id3          1998-03-04 00:00:00.000
id2          2000-02-20 00:00:00.000(3 row(s) affected)

Answer 4

create table tt
(a char(12),
b datetime
)create    PROCEDURE ttt
@manual_no char(12),
@start_vaild_day  datetime
AS
insert into  tt(a,b)
values   (@manual_no,@start_vaild_day)
goexec ttt @manual_no='2',@start_vaild_day='2003-07-17 19:36:38.250'go
没问题的