奇怪的问题：为什么nvchar转换为datetime时出错

Question

AddProcess '200612582','2008-11-18','4','21','43','24','','29','cc8','2008-11-18 9:50:06'
CREATE  procedure AddProcess
    @teacherid int,
    @ProcessTime datetime,
    @ProcessHold nvarchar(10),
    @ProcessType nvarchar(2),
    @ProcessContent nvarchar(255),
    @ProcessStyle char(2),
    @ProcessAbout nvarchar(20),
    @ProcessRole char(2),
    @AddTime datetime,
    @AddUser nvarchar(10)
'cc8'不能转换成datetime

Answer 1

确定传入的date类型参数为date
if isdate(@AddTime)=1

Answer 2

--'cc8'不能转换成datetime 非標準時間字符~~~
--try
exec AddProcess '200612582','2008-11-18','4','21','43','24','','29',gedate(),'2008-11-18 9:50:06'