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].[spDeleteNHID] -- Add the parameters for the stored procedure here @NHID varChar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DELETE FROM tblFacilities WHERE tblFacilities.nhid = '@NHID'; DELETE FROM tblFacilityInfo WHERE tblFacilityInfo.nhid = '@NHID'; DELETE FROM tblDataLogging WHERE tblDataLogging.nhid = '@NHID'; DELETE FROM tblMaterials WHERE tblMaterials.nhid = '@NHID'; DELETE FROM tblMileage WHERE tblMileage.nhid = '@NHID'; DELETE FROM tblToComplete WHERE tblToComplete.nhid = '@NHID'; 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.