declare @count int set @count= '' declare @sql nvarchar(4000) set @sql= 'select @count=count(*) from a' exec sp_executesql @sql,N'@count int output' ,@count outputselect @count改下表名就可以了
稍微改下楼上 declare @count int declare @sql nvarchar(4000) set @sql= 'select @cnt=count(*) from table' exec sp_executesql @sql,N'@cnt int output' ,@count outputselect @count
declare @Num int select @Num=count(*) from ta print @Num
declare @count as int select @count=count(*) from table 这样就可以了
declare @Num int select @Num=count(*) from ta print @Num
--以下查询northwind中Customers表的记录数 --方法1: declare @count int declare @sql nvarchar(4000) set @sql= 'select @i=count(*) from Customers' exec sp_executesql @sql,N'@i int output' ,@count outputselect @count--方法2: declare @i int select @i=count(*) from Customers select @i
DECLARE @PPP VARCHAR(60)SET @PPP='SELECT COUNT(*) FROM PPP ' EXEC(@PPP)
DECLARE @PPP VARCHAR(60)SET @PPP='SELECT COUNT(*) FROM PPP ' EXEC(@PPP)
DECLARE @PPP VARCHAR(60)SET @PPP='SELECT COUNT(*) FROM PPP ' EXEC(@PPP)
declare @Num int select @Num=count(*) from ta print @Num
set @count= ''
declare @sql nvarchar(4000)
set @sql= 'select @count=count(*) from a'
exec sp_executesql @sql,N'@count int output' ,@count outputselect @count改下表名就可以了
稍微改下楼上
declare @count int
declare @sql nvarchar(4000)
set @sql= 'select @cnt=count(*) from table'
exec sp_executesql @sql,N'@cnt int output' ,@count outputselect @count
declare @Num int
select @Num=count(*) from ta
print @Num
select @count=count(*) from table
这样就可以了
select @Num=count(*) from ta
print @Num
--方法1:
declare @count int
declare @sql nvarchar(4000)
set @sql= 'select @i=count(*) from Customers'
exec sp_executesql @sql,N'@i int output' ,@count outputselect @count--方法2:
declare @i int
select @i=count(*) from Customers
select @i
EXEC(@PPP)
EXEC(@PPP)
EXEC(@PPP)
select @Num=count(*) from ta
print @Num