Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
ALTER PROCEDURE [dbo].[SP_Complete_Transaction] @id int AS BEGIN BEGIN TRAN Complete_Transaction SET NOCOUNT ON; If ( (select sum(amount) as amount from subtransaction where transactionsid=@id and status=2) = (select amount from transactions where id=@id and status=2) and (select sum(payoutamount) as payoutamount from subtransaction where transactionsid=@id and status=2) = (select countervalue from transactions where id=@id and status=2) ) update transactions set status = 3 where id =@id update subtransaction set status = 3 where transactionsid =@id ELSE select id from transactions where id=@id IF @@ERROR <> 0 ROLLBACK TRAN Complete_Transaction ELSE COMMIT TRAN Complete_Transaction END
|How to "ASSIGN" a RecordID based on 1st character of a Field?||8||35|
|sql server bcp "SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file"||6||55|
|Divide by zero error encountered.||2||33|
|Help with SQL - TOP 10 by date and by group||13||34|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!