Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
ALTER PROCEDURE [dbo].[spSoftwareDelete] @SoftwareID int As BEGIN Delete From tblSoftware Where SoftwareID = @SoftwareID if @@Error>0 Begin -- Set @msg = @msg + '; SQL Server error: ' + CAST(@@Error AS NVARCHAR(10)) -- Raise an error and return RAISERROR ('There are some records with this SoftwareID in tblOrderDetails; cannot delete this item..', 16, 1) RETURN @@ERROR End END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.