Trying to Determine What a Declared Variable Will Return

I was given this scenario, and need to determine what a specific declared variable would return:

Table:  Employees
ID int not null
F_Name varchar(50) not null
L_Name varchar(100) not null

DECLARE @ColumnName varchar(255)
SET @ColumnName = "

SET @ColumnName = 
         (
              SELECT MIN(QUOTENAME(COLUMN_NAME))
                    FROM Information_Schema.Columns
                      WHERE Table_Name = "Employees"
                          AND Data_Type IN ('char','varchar','nchar','nvarchar')
         )


Will it return ID, F_Name, L_Name or will it return an Error?

Thanks,

gdunn59

Select allOpen in new window