Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
SET NOCOUNT ON; DECLARE @intErrorCode INT BEGIN TRANSACTION SET @TID=(select (counterfrom + currentcounter) from e_counter SELECT @intErrorCode = @@ERROR IF (@intErrorCode <> 0) GOTO PROBLEM insert into e_Login (id,Username,Password) values (@TID, 'U-','U-') SELECT @intErrorCode = @@ERROR IF (@intErrorCode <> 0) GOTO PROBLEM UPDATE e_counter set currentcounter=(currentcounter + 1) where functionno=@FUNID SELECT @intErrorCode = @@ERROR IF (@intErrorCode <> 0) GOTO PROBLEM COMMIT TRANSACTION PROBLEM: IF (@intErrorCode <> 0) BEGIN ROLLBACK TRAN SET @TID=0 END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|denied execute as||13||57|
|ASP.NET Complete Life Cycle for all the controls||2||43|
|T-SQL: The transaction log for database 'Logging' is full due to 'LOG_BACKUP'||3||58|
|Adding columns to a table which has non null columns||3||40|
Join the community of 500,000 technology professionals and ask your questions.