求教赋值问题(回复有分)

[qcbao]

declare @v decimal(18,4)
declare @strsql varchar(1000)

set @strsql = '(1.9+3)*5.6'

将@strsql的表达式的值传给@v,而@strsql的表达式是不断变化的

[taoqingxue]

up

[pengdali]

declare @v decimal(18,4)
declare @strsql nvarchar(1000)

set @strsql = N'set @a=(1.9+3)*5.6'

exec sp_executesql @sql,N'@a numeric(10,4) output',@v output

[CrazyFor]

参考:

declare @tcnt int
declare @paras varchar(100)
DECLARE @SQLString NVARCHAR(500)
set @paras ='1,3,5'
set @sqlstring=N'select @cnt=count(*) from sysobjects where id in ('+@paras+')'

set @tcnt=0
execute sp_executesql
@sqlstring,
N'@cnt int output',
@cnt=@tcnt output
select @tcnt


select * from sysobjects


参考:
Create Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end

[wzh1215]

declare @v decimal(18,4)
declare @strsql nvarchar(1000)

set @strsql = N'set @a=(1.9+3)*5.6'

exec sp_executesql @strsql,N'@a numeric(10,4) output',@v output
select @v

[qcbao]

感谢各位