34,588
社区成员
发帖
与我相关
我的任务
分享
declare @num int,
@sqls nvarchar(4000)
set @sqls='select count(*) from tableName'
exec(@sqls)
--如何将exec执行结果放入变量中?
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[sp_TestGetReportData]
-- Add the parameters for the stored procedure here
(
@Result varchar(2000) output --声明输出变量
,@strDataBase varchar(40)
)
AS
declare @nTodayIn float --本日入库
declare @strSql varchar(2000)
set @nTodayIn=0;
set @strDataBase='UFDATA_002_2009';
set @strSql='';
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
set @nTodayIn=0;
set @strSql='SELECT top 1 ['+ltrim(@nTodayIn)+']= b.iquantity from '+@strDataBase +'.dbo.rdrecords b';
Exec(@strSql);
END