create procedure CheckUnique
@tab varchar(64),
@field varchar(64),
@value varchar(64)
as
begin
declare @strSQL varchar(2048)
set @strSQL = ' select count(*) as numb from %1% where %2% = ''%3%'' '
set @strSQL = replace(@strSQL, '%1%', @tab)
set @strSQL = replace(@strSQL, '%2%', @field)
set @strSQL = replace(@strSQL, '%3%', @value)
execute(@strSQL)
end
GO