exec sp_executesqlt向表中添加纪录,字段有日期格式的.大家帮忙啊!
ALTER PROCEDURE [dbo].[test](
@Date DateTime,
@ClassID int
)
AS
declare @Sql nvarchar(1000)
set @Sql=
'
insert into muDay(JudgeDay, Class_ID)
values('+CONVERT(varchar(10),@Date,120 )+','+cast(@ClassID as nvarchar)+')
'
exec sp_executesql @Sql --------------------编程问答-------------------- 数据库中JudgeDay是datetime类型的
补充:.NET技术 , ASP.NET