SQLServer查询所有字段并将xtype转换为字符串

查询语句

select c.* from syscolumns c, sysobjects t where c.id = t.id and t.type = 'U' and t.name = ?

查询结果中name表示字段名，xtype表示字段类型，但是用数字表示的，进行转换

switch (num) {
            default:
                result = "VARCHAR";
            case "34":
                result = "IMAGE";
                break;
            case "35":
                result = "TEXT";
                break;
            case "36":
                result = "UNIQUEIDENTIFIER";
                break;
            case "48":
                result = "TINYINT";
                break;
            case "52":
                result = "SMALLINT";
                break;
            case "56":
                result = "INT";
                break;
            case "58":
                result = "SMALLDATETIME";
                break;
            case "59":
                result = "REAL";
                break;
            case "60":
                result = "MONEY";
                break;
            case "61":
                result = "DATETIME";
                break;
            case "62":
                result = "FLOAT";
                break;
            case "98":
                result = "SQL_VARIANT";
                break;
            case "99":
                result = "NTEXT";
                break;
            case "104":
                result = "BIT";
                break;
            case "106":
                result = "DECIMAL";
                break;
            case "108":
                result = "NUMERIC";
                break;
            case "122":
                result = "SMALLMONEY";
                break;
            case "127":
                result = "BIGINT";
                break;
            case "165":
                result = "VARBINARY";
                break;
            case "167":
                result = "VARCHAR";
                break;
            case "173":
                result = "BINARY";
                break;
            case "175":
                result = "CHAR";
                break;