ALTER PROCEDURE [dbo].[sp_TestSetupHardwareGet] @TestSetupId INT = NULL AS BEGIN SET NOCOUNT ON; IF( @TestSetupId IS NULL) BEGIN SELECT TestSetupHardwareId, DASId, TestSetupId, AddOrRemove, SamplesPerSecond, IsClockMaster, AntiAliasFilterRate FROM [dbo].TestSetupHardware END ELSE BEGIN SELECT TestSetupHardwareId, DASId, TestSetupId, AddOrRemove, SamplesPerSecond, IsClockMaster, AntiAliasFilterRate FROM [dbo].TestSetupHardware WHERE [TestSetupId]=@TestSetupId END END;