Try this way..

DECLARE @CNT2 VARCHAR(100)

SET @sqlquery = N'SELECT @CNT = COUNT(*) FROM [' + @TableName + '] WITH (NOLOCK) WHERE [' + @ColumnName + ']= ' + CHAR(39) + @Value + CHAR(39)

SP_EXECUTESQL @sqlquery, N'@CNT INT OUT', @CNT2 OUT

if EXISTS(@CNT2>0)

BEGIN

SET @sqlquery = N'SELECT ' + CHAR(39) +@TableName + CHAR(39) + ' AS TableName,* FROM [' + @TableName + '] WITH (NOLOCK) WHERE [' + @ColumnName + ']= ' + CHAR(39) + @Value + CHAR(39)

EXEC SP_EXECUTESQL @sqlquery

END