我正在尝试创建一个存储过程,该过程运行选择查询并提取一个ID(变量),然后对该ID进行更新查询。任何帮助,将不胜感激。
这就是我所拥有的:
CREATE PROCEDURE dbo.Lead_usp_getLead
@LeadId int output
AS
SELECT TOP 1
Leadid, LeadInitials, LeadFirstName, LeadSurname,
LeadHomeTelephoneNumber, LeadWorkTelephoneNumber,
LeadCellularNumber, LeadEMailAddress, IsLocked, uploadedDate
FROM
dbo.Lead
WHERE
IsLocked = 'False'
ORDER BY
uploadedDate;
UPDATE dbo.Lead
SET IsLocked = 'TRUE'
WHERE LeadId = @LeadId
DECLARE @leadid int
EXEC dbo.Lead_usp_getLead @leadId;
您可以将它们结合在一起。无需执行两个查询:
with toupdate as (
SELECT TOP 1 l.*
FROM dbo.Lead l
WHERE l.IsLocked = 'False'
ORDER BY l.uploadedDate
)
Update toupdate
SET IsLocked = 'TRUE';
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句