create view test_view
as
select id,name,时间=(cast(nian as varchar)+'-'+cast(yue as varchar)+'-'+cast(ri as varchar)+' '+cast(shi as varchar)+':'+(cast fen as varchar)+':'+(cast miao as varchar)) from test
as
select id,name,时间=(cast(nian as varchar)+'-'+cast(yue as varchar)+'-'+cast(ri as varchar)+' '+cast(shi as varchar)+':'+(cast fen as varchar)+':'+(cast miao as varchar)) from test
解决方案 »
- 关于Sqlserver like的简写
- char和varchar自动截断不用触发器可能吗? 事件探查器里和查询分析器结果为何不一致?
- Update SET 语句问题···
- 如何编个sql语句把一列的值经过处理后加到另一列上(在线等)
- 请问谁有CSDN MSSQL问题集 谢谢
- 还是日期问题,在线结分
- 请问,如何用sqldmo得到字段的默认值及说明?
- 联合查询更新求指教
- 关于存储过程调用存储过程的问题(着急呀!):
- 用_ConnectPtr的OpenSchema可以得到字段的类型吗,我用ado连接数据库,
- 如何用存储过程连接text类型的字段
- WIN2000SERVER下SQL SERVER2000安装不下去
select id ,字段=cast(nian as varchar(4))+'-'+cast(yue as varchar(4))+'-'+cast(ri as varchar(4))+' '+cast(shi as varchar(4))+':'+cast(fen as varchar(4))+':'+cast(miao as varchar(4)) from test