34,590
社区成员
发帖
与我相关
我的任务
分享
declare @strSql varchar(3000), @sign int
DECLARE @t TABLE(ID int)
set @strSql = 'if exists(select 1 from tablename) select 1'
INSERT INTO @t EXEC(@strSql)
SET @sign=ISNULL((SELECT ID FROM @t),0)
SELECT @sign
declare @strSql varchar(3000), @sign int
set @strSql = 'select top 1 1 from tablename'
EXEC(@strSql)
if @@rowcount>0
set @sign = 1
else
set @sign = 0
declare @strSql nvarchar(3000)
declare @sign int
set @strSql = N'select @sign = count(*) from tablename'
exec sp_executesql @strSql,'@sign int output',@sign output
if @sign > 0
set @sign = 1
else
set @sign = 0