关于数据不兼容问题

[boymaster]

在存储过程中用insert一个表记录，当表字段同时有datetime/text型内容时，就出现“错误 206: 操作数类型冲突: text 与 datetime 不兼容”.
请教高手一下，如何解决
declare @pID varchar(9)
declare @inDate datetime
declare @kcid int
declare @iDept int
declare @classid int
declare @knum int
declare @price money
declare @total money
declare @content text

set @pID='I0000001'
set ...

set @sql='insert 库存账本 (Dateandtime,pID,pDept,classid,jNum,jMoney,jSum,'+
'cNum,cMoney,cSum,content,Counts,kc'+cast(@kcid as char(1))+') values (' +
@inDate+','+@pID+','+@iDept+','+@classid+','+@kNum+','+@price+','+@total+','+
@kNum+','+@price+','+@total+','+@content+','+@kNum+','+@kcNum+')'
exec sp_executesql @sql

[zjcxc]

set @sql='insert 库存账本 (Dateandtime,pID,pDept,classid,jNum,jMoney,jSum,
cNum,cMoney,cSum,content,Counts,kc'+cast(@kcid as char(1))+')
values (@inDate,@pID,@iDept,@classid,@kNum,@price,@total
,@kNum,@price,@total,@content,@kNum,@kcNum)'
exec sp_executesql @sql
,N'@pID varchar(9),@inDate datetime,@kcid int,@iDept int,@classid int
@knum int,@price money,@total money,@content text'
,@pID ,@inDate ,@kcid ,@iDept ,@classid
@knum ,@price,@total,@content