SQLSERVER技术
-
编辑 删除
SQLServer中动态查询sql返回值给变量的方法
1) DECLARE @tbname sysname,@sql varchar(100) SET @sql='SELECT '+@tbname+'=name FROM sysobjects where id=1' EXEC(@sql) SELECT @tbname 2) declare @num int, @sqls nvarchar(4000) set @sqls='select @a=count(*) from tableName ' exec sp_executesql @sqls,N'@a int output',@num output [@more@]
-
博文量108
-
访问量790618
