executescalar in sql server
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
Are there any code examples left?
New code examples in category SQL