DECLARE @IsDuplicate BIT IF EXISTS(SELECT * FROM dbo.ListData WHERE [description] = @description AND [dataTypeId] = @dataTypeId) -- Checking if duplicate name SET @IsDuplicate = 1 ELSE BEGIN END