sql数据类型转换

[橙-极纪元JJYCheng]

sql数据类型转换 怎么讲varchar 类型转换程int类型

[橙-极纪元JJYCheng]

大家帮帮忙不慎感激

[快溜]

cast(varchar as int) where isnumeric(varchar)=1

[q465897859]

纯数字的应该能转 你是的话貌似转不了

[q465897859]

select CONVERT(int,'11')+11

[橙-极纪元JJYCheng]

declare @num varchar(200);
declare @intnum int
set @num='select count(jiage) from ceshidaata' ;

set @intnum=CAST(@num as int );


提示
消息 245，级别 16，状态 1，第 6 行
在将 varchar 值 'select count(jiage) from ceshidaata' 转换成数据类型 int 时失败。

[--小F--]

cast(col as int)

[--小F--]

cast(col as int) where isnumeric(varchar)=1

[快溜]

set @num='select count(jiage) from ceshidaata' ;

你这样写是获取不到count的

[橙-极纪元JJYCheng]

[Quote=引用 8 楼 ssp2009 的回复:]
set @num='select count(jiage) from ceshidaata' ;

你这样写是获取不到count的
[/Quote]


可以获取到吧

[快溜]

DECLARE @sql NVARCHAR(100),@intnum int
SET @sql = N'select @intnum=count(*) from tb1'
exec sp_executesql @sql, N'@intnum int output', @intnum output
PRINT @intnum

[橙-极纪元JJYCheng]

[Quote=引用 10 楼 ssp2009 的回复:]
SQL code

DECLARE @sql NVARCHAR(100),@intnum int
SET @sql = N'select @intnum=count(*) from tb1'
exec sp_executesql @sql, N'@intnum int output', @intnum output
PRINT @intnum
[/Quote]

谢谢啊 呵呵