sql server 字符类型转换有两种方式:
1.cast
CAST ( expression AS data_type )
如
select cast( '123 ' as int)
2.convert
CONVERT (data_type[(length)], expression [, style])
如
select convert(int, '123 ')
sql server 字符类型转换有两种方式:
1.cast
CAST ( expression AS data_type )
如
select cast( '123 ' as int)
2.convert
CONVERT (data_type[(length)], expression [, style])
如
select convert(int, '123 ')