22,297
社区成员
发帖
与我相关
我的任务
分享sql这样写可以吗？
insert into Base_feemark(StationID,TollDate,Mark) values(select StationID,convert(char,getdate(),122),ISUSE from Base_Station290)
...全文
请发表友善的回复…
发表回复
htl258_Tony 2009-03-26
- 打赏
- 举报
sdhdy说得没错，楼主没加字符串长度，最好用varchar，不用char.
sdhdy 2009-03-26
- 打赏
- 举报
[Quote=引用楼主 guowei1651 的帖子:]
insert into Base_feemark(StationID,TollDate,Mark) values(select StationID,convert(char,getdate(),122),ISUSE from Base_Station290)
[/Quote]
insert into Base_feemark(StationID,TollDate,Mark) values(select StationID,convert(char,getdate(),122),ISUSE from Base_Station290)
[/Quote]
--122？
convert(char,getdate(),122)sdhdy 2009-03-26
- 打赏
- 举报
insert into Base_feemark(StationID,TollDate,Mark)
select StationID,convert(varchar(8),getdate(),112),ISUSE from Base_Station290htl258_Tony 2009-03-26
- 打赏
- 举报
insert into Base_feemark(StationID,TollDate,Mark) select StationID,convert(char,getdate(),122),ISUSE from Base_Station290
