Your technology certification is waiting. Enroll in Cloud Class ®
declare @temp table(DealID int,afsLocked int,afsServiced int,afsPaComplete int)
declare @Var1 int,@Var2 int,@Var3 int
select @Var1 = afsLocked,@Var2 = afsServiced,@Var3 = afsPaComplete
Open in new window
CREATE PROC sp_Lockedget(
@Var1_OUT bit OUTPUT,
@Var2_OUT bit OUTPUT,
@Var3_OUT bit OUTPUT
SET NOCOUNT ON
@Var1_OUT = afsLocked,
@Var2_OUT = afsServiced,
@Var3_OUT = afsPaComplete
WHERE DealID = @DealID
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.