CREATE PROC PR_TEST ( @PA_VAR1 VARCHAR(100) ) AS BEGIN DECLARE @CNT INT SELECT @CNT=COUNT(*) FROM YOUR_TABLE WHERE COL=@PA_VAR1 IF @CNT > 1 BEGIN SELECT 'VALID' END ELSE BEGIN SELECT 'INVALID' END END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)