sql语句怎么连接数字类型变量?
declare @Strsql varchar(2000),@iagefrom int,@iageto int
set @iagefrom=25
set @iageto=100
set @Strsql='select * from members where age between '''+iagefrom+''' and '''+iageto+''''
--这样不行
--这种方法只适合字符串类型的变量,但数字类型的变量有问题,数字类型的 变量该怎么连接呢?
exec(@Strsql)