储存过程帮忙查错和优化
Create Procedure Out
@Url nvarchar(4000) Output
As
Declare @OutTemp Int
Declare @ID Int
--在System取出OutTemp值
Select @OutTemp = OutTemp From System
--在Users表中检索出比OutTemp大的一个ID,并返回@Url
Select Top 1 @Url = Url From Users Where ID > @OutTemp
Go