Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.
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
Join the community of 500,000 technology professionals and ask your questions.