如何把这两列合并成一列smalldatetime字段？

[newline]

把字符串'2003-12-21'和'17:26:08'合并成smalldatetime字段。

[newline]

谢谢，再不结贴分就不够给了，呵呵！

[tiny_yan]

select convert(smalldatetime,'2003-12-21'+space(1)+'17:26:08')

[tiny_yan]

select convert(smalldatetime,字段1+space(1)+字段2) from 表

[aierong]

select convert(smalldatetime,'2003-12-21'+' '+'17:26:08')

[klan]

try this
convert(smalldatetime,'2003-12-21'+' '+'17:26:08')

[aierong]

create view vi
as
select *,convert(smalldatetime,i+' '+ii) h
from tablename


利用视图可以得到合并列h

[dlpseeyou]

select cast('2003-12-21'+' '+'17:26:08' as datetime)