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

曾经终败给现在 2023-02-25 15:28 8阅读 0赞

### 查询语句 ###

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;