問題描述
我有一個 SQL 查詢，用于查詢我不需要也不想理解的龐大(例如，數(shù)百個視圖/表的名稱難以閱讀，如 CMM-CPP-FAP-ADD)數(shù)據(jù)庫.此查詢的結(jié)果需要存儲在臨時表中以提供報告.
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.
我需要創(chuàng)建臨時表，但要挖掘數(shù)百個視圖/表以找到此處表示的數(shù)據(jù)類型，我想知道是否有更好的方法來構(gòu)建此表.
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 數(shù)據(jù)庫中的源數(shù)據(jù)類型?
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
我想知道的不是實際結(jié)果:
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
我對約束不感興趣，我真的只想知道數(shù)據(jù)類型.
I'm not interested in constraints, I really just want to know the data types.
推薦答案
select * from information_schema.columns
可以幫助您入門.
這篇關(guān)于如何從查詢中返回 SQL 數(shù)據(jù)類型?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！