多条数据插入问题

[wubin123456]

当天时间是 NewDate

iNSERT INTO UserSalary_Days(UserName,zz, createdate)

selecct username ,zz from sys_user



怎么把NewDate 也同时插入进去

[wubin123456]

顶！急

[wangdehao]

select getdate()

[paoluo]

iNSERT INTO UserSalary_Days(UserName,zz, createdate)

selecct username ,zz, GetDate() from sys_user

[wubin123456]

是直接补到后面吗楼住

[mengmou]

iNSERT INTO UserSalary_Days(UserName,zz, createdate)

selecct username ,zz,getdate() from sys_user

[dawugui]

INSERT INTO UserSalary_Days(UserName,zz, createdate)
selecct username ,zz ,getdate() from sys_user

[wubin123456]

我这个日期是个变量不是系统时间？？？

[wangdehao]

iNSERT INTO UserSalary_Days(UserName,zz, createdate)

selecct username ,zz,getdate() from sys_user

[dawugui]

不要时间,只要日期是吧?

INSERT INTO UserSalary_Days(UserName,zz, createdate)
selecct username ,zz ,convert(varchar(10),getdate(),120) from sys_user

[paoluo]

wubin123456(1) ( ) 信誉：100 Blog 2007-03-16 15:48:49 得分: 0


我这个日期是个变量不是系统时间？？？


---------

一樣的做法

Declare @Dt DateTime
Select @Dt = '2007-03-01'

iNSERT INTO UserSalary_Days(UserName,zz, createdate)

select username ,zz, @Dt from sys_user

[wubin123456]

呵呵
我可真菜！谢谢各位不断学习中

[wangdehao]

wubin123456(1) ( ) 信誉：100 Blog 2007-03-16 15:48:49 得分: 0


我这个日期是个变量不是系统时间？？？

当天时间是 NewDate?
declare @dt datetime
set @dt='2007-01-01'
iNSERT INTO UserSalary_Days(UserName,zz, createdate)
select username ,zz,@dt from sys_user