34,590
社区成员
发帖
与我相关
我的任务
分享
declare @ver int
select @ver=count(*) from t_credit where [name] = @name group by [name],ver having count(*) > 1
-- 如何判断是否有记录?
select @@rowcount
-- 如何取出变量 ver?
declare @v [ver数据类型]
select top 1 @v=ver
from t_credit
where [name]=@name
group by [name],ver
having count(*)>1
order by ver desc
create proc dbo.xxx
@ver int output --输出参数
as
select top 1 @ver = count(*) from t_credit where [name] = @name
group by [name],ver having count(*) > 1
order by ver desc
go
declare @ver int;
exec dbo.xxx @ver output
select @ver