如何从查询中返回 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
可以帮助您入门.
相关文章