如何从查询中返回 SQL 数据类型?

问题描述

我有一个 SQL 查询，用于查询我不需要也不想理解的庞大(例如，数百个视图/表的名称难以阅读，如 CMM-CPP-FAP-ADD)数据库.此查询的结果需要存储在临时表中以提供报告.

I've a SQL query that queries an enormous (as in, hundreds of views/tables with hard-to-read names like CMM-CPP-FAP-ADD) database that I don't need nor want to understand. The result of this query needs to be stored in a staging table to feed a report.

我需要创建临时表，但要挖掘数百个视图/表以找到此处表示的数据类型，我想知道是否有更好的方法来构建此表.

I need to create the staging table, but with hundreds of views/tables to dig through to find the data types that are being represented here, I have to wonder if there's a better way to construct this table.

谁能建议我如何使用任何 SQL Server 2008 工具来确定 SQL 2000 数据库中的源数据类型?

Can anyone advise how I would use any of the SQL Server 2008 tools to divine the source data types in my SQL 2000 database?

作为一般示例，我想从以下查询中了解:

As a general example, I want to know from a query like:

SELECT Auth_First_Name, Auth_Last_Name, Auth_Favorite_Number 
FROM Authors

我想知道的不是实际结果:

Instead of the actual results, I want to know that:

Auth_First_Name is char(25)
Auth_Last_Name is char(50)
Auth_Favorite_Number is int

我对约束不感兴趣，我真的只想知道数据类型.

I'm not interested in constraints, I really just want to know the data types.

推荐答案

select * from information_schema.columns

可以帮助您入门.

这篇关于如何从查询中返回 SQL 数据类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！