Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|How to convert number 123.8 to 1238, removing decimal, in SQL query?||5||19|
|Handle null when using linq in this line||1||20|
|SQL Server can be started but not accessed||1||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!