DECLARE @col sysname = 'Guid'
DECLARE @sql VARCHAR(MAX) = ''

SELECT @sql  += N' SELECT  TOP 1 ' + QUOTENAME(Name,'''') + ' FROM [' + Name  + '] WHERE ' + @col + ' IS  NULL;'
FROM sys.tables 
WHERE object_id IN ( SELECT id 
              FROM syscolumns 
              WHERE name = @col )

DECLARE @Result TABLE (TableName sysname)

INSERT INTO @result(TableName)
EXEC (@sql)

SELECT * FROM @Result