CREATE PROCEDURE usp_InsertorUpdateSiteDetail
@set_it varchar(50
ASdeclare @strTmp varchar(255)set nocount on
set @strTmp = 'select count(*) as num from tbl_site_detail where set_it = '''+@set_it+''''GO我想根据上述SQL语句中的纪录数作为条件
如何返回count(*)的值给一个变量呢,谢谢
@set_it varchar(50
ASdeclare @strTmp varchar(255)set nocount on
set @strTmp = 'select count(*) as num from tbl_site_detail where set_it = '''+@set_it+''''GO我想根据上述SQL语句中的纪录数作为条件
如何返回count(*)的值给一个变量呢,谢谢
AS
declare @strTmp varchar(255)
declare @num int
set nocount on
select @num=count(*) from tbl_site_detailwhere set_it = @set_it
select @num
GO