All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.
Thanks a lot in advance
USE [STRAINING] GO /****** Object: StoredProcedure [dbo].[sp_SignUp] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_SignUp] @cosID int, @locid int, @dat int, @UserName varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. declare @error varchar(max) SET NOCOUNT ON; if exists(SELECT * FROM tblTrainings WHERE Username = @UserName AND CourseID = @cosID AND LocationID = @locid AND dateId = @dat) begin set @error = 'You have already signed up for this training' raiserror(@ERROR, 12, 1) end else DECLARE @seatsAvailable int SET @seatsAvailable = 0; SELECT @seatsAvailable = (select Seating_Capacity - (select count(*) from tblTrainings WHERE CourseId=@cosID ) FROM tblLocations WHERE LocationId = @locID ) if @seatsAvailable > 0 begin INSERT INTO tblTrainings (CourseId, LocationId, dateId, username) VALUES (@CosID, @LocID, @dat, @Username) set @error = Registration is successful' raiserror(@ERROR, 13, 1) end else begin INSERT INTO tblWaitingList (CourseId, LocationId, dateId, username) VALUES (@CosID, @LocID, @dat, @Username) set @error = 'You have been placed on the waiting list. You will be immediately notified if a seat is available' raiserror(@ERROR, 14, 1) end END
|Move SQL 2005 Express to Server 2012R2||19||73|
|Which software should I use if I want to develop a simple native app that will sync sql lite to sql server||4||53|
|Sql to find top3 for each record||7||18|
|Delete Trigger in SQL Server2008R2||5||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!