while downvoting, it should also ask for a comment for the reason and might be display as reason for downvoting to the author (it can still be anonymous)?
R
Rohit Shrivastava
@Rohit Shrivastava
Posts
-
Downvoting limits? -
SQL Select Where queryHi Joe, You can use following query:
SELECT ISNULL( (SELECT File_Name
FROM Files
WHERE File_Name = @FileName1),1)This would solve your problem, in case there is no result, it will return you 1 otherwise the matching result.