insert into dbo.tb_HRMRWJBXXB
(Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD)
select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),
gji,csd,yxmc,
cast(year(csrq) as varchar(4))+'-01'+'-01',jygl,
smcz,6 from OldAliumData.dbo.JBXXk
(Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD)
select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),
gji,csd,yxmc,
cast(year(csrq) as varchar(4))+'-01'+'-01',jygl,
smcz,6 from OldAliumData.dbo.JBXXk
解决方案 »
- 关于TreeNode的应用!
- 外行求解答~~上传数据到服务器,求搭建环境。
- 刚才结贴结错了,imfor来接分吧
- DataNavigateUrlFields="title" DataNavigateUrlFormatString="article_detail.aspx?articleTitle=Server.UrlEncode({0})"
- 发送消息问题!各位大虾帮忙!在线等!立即给分!
- 新安装了vs2005,但打开网站时,出现了错误:访问 IIS 元数据库失败,用于运行 ASP.NET 的进程帐户必须具有对 IIS 元数据库(如 IIS://servern
- 再次提问,如何将滚动条固定在最顶端而不会向下滚动??我现在是页面刷新时再将他滚动到最顶端,但这样回引起页面的闪动,有什么好办法吗
- 大家看看,是什么问题呀!一个新手的问题!
- 有没有一个重写的文本输入框以及判断非空的控件的组合自定义控件?
- 弹出对话框
- 关于分组输出
- 关于updatepanel中gridview刷新的问题
select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),gji,csd,yxmc,
convert(varchar(4),Csrq,120)+'-01'+'-01',jygl,
smcz,6 from OldAliumData.dbo.JBXXk--或者
datepart(yy,Csrq)+'-01'+'-01'
insert into dbo.tb_HRMRWJBXXB
(Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD)
select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),
gji,csd,yxmc,
cast((substring(csrq,1,4)+'-01-01')as datetime),jygl,
smcz,6 from OldAliumData.dbo.JBXXk
test code:
select cast( (substring(t,1,4)+'-01-01') as datetime)
from
(
select '1999-01-01' as t
union all
select '1999' as t
union all
select '2000.1' as t
union all
select '2000-1-1' as t
union all
select '1999.1' as t
) A
test result 1999-01-01 00:00:00.000
1999-01-01 00:00:00.000
2000-01-01 00:00:00.000
2000-01-01 00:00:00.000
1999-01-01 00:00:00.000
insert into dbo.tb_HRMRWJBXXB (Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD)
select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),gji,csd,yxmc,
CONVERT(nvarchar(10),csrq,112),jygl,smcz,6 from OldAliumData.dbo.JBXXk
select CONVERT(nvarchar(10),Getdate(),112)----------------------
--结果
20090625
select CONVERT(nvarchar(4),Getdate(),112)+'-01-01'
(Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD) select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),gji,csd,yxmc,
CONVERT(DATETIME,DATENAME(YY,csrq)+'-01'+'-01')),jygl, smcz,6 from OldAliumData.dbo.JBXXk
能否把你的数据给提供出来,然后将csrq类型也弄出来,看看!
insert into dbo.tb_HRMRWJBXXB
(Rwjbxxid, Alumniid,Xm,XBM,Gjm,Csd,Cssym,Csrq,YJ,FMCZ,XXKXD) select NewID(),newId(),zwxm,(case when Rtrim(xb)='男' then '1' else '2' end),gji,csd,yxmc,
LEFT(LTRIM(csrq),4)+'-01'+'-01',jygl, smcz,6 from OldAliumData.dbo.JBXXk 你插入另外表时,符合时间的VARCHAR 会转成DATETIME型的,