blocks|key|1723023|text|select+*+from+information_schema.columns|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1723024|可以帮你入门。|unstyled|1723025|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>select * from information_schema.columns
</code></pre>

could get you started.

blocks|key|424152|text|您是否可以在每次执行查询时从头开始重新创建临时表？如果是这样，您可以使用SELECT+...+INTO语法，让SQL+Server考虑如何使用正确的列类型创建表，等等。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|424153|SELECT+*
INTO+your_staging_table
FROM+enormous_collection_of_views_tables_etc|code-block|syntax|javascript|424154|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms188029.aspx^0|10|F|10|F|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Can you get away with recreating the staging table from scratch every time the query is executed? If so you could use <a href="http://msdn.microsoft.com/en-us/library/ms188029.aspx" rel="noreferrer"><code>SELECT ... INTO</code></a> syntax and let SQL Server worry about creating the table using the correct column types etc.

<pre><code>SELECT *
INTO your_staging_table
FROM enormous_collection_of_views_tables_etc
</code></pre>

blocks|key|424684|text|您也可以使用...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|424685|SQL_VARIANT_PROPERTY()|code-block|syntax|javascript|424686|无法直接访问元数据的...in情况(例如，可能是链接服务器查询？)|424687|424688|SQL_VARIANT_PROPERTY+(Transact-SQL)|unordered-list-item|offset|length|424689|424690|在SQL+Server2005及更高版本中，与INFORMATION_SCHEMA相比，您最好使用目录视图(sys.columns)。除非到其他平台的可移植性很重要。请记住，INFORMATION_SCHEMA视图不会改变，因此在SQL+Server的后续版本中，它们将逐渐缺乏有关新功能等的信息。|424691|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql^0|0|0|0|0|0|Z|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@$M|14|N|15|1|16]]|A|$]]|$1|O|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|18|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

You can also use...
<pre><code>SQL_VARIANT_PROPERTY()
</code></pre>
...in cases where you don't have direct access to the metadata (e.g. a linked server query perhaps?).
<ul>
<li><a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql" rel="nofollow noreferrer">SQL_VARIANT_PROPERTY (Transact-SQL)</a></li>
</ul>
In SQL Server 2005 and beyond you are better off using the catalog views (sys.columns) as opposed to INFORMATION_SCHEMA. Unless portability to other platforms is important. Just keep in mind that the INFORMATION_SCHEMA views won't change and so they will progressively be lacking information on new features etc. in successive versions of SQL Server.

blocks|key|1723516|text|select+COLUMN_NAME,+DATA_TYPE,+CHARACTER_MAXIMUM_LENGTH+
from+INFORMATION_SCHEMA.COLUMNS+
where+TABLE_NAME='yourTable';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1723517|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH 
from INFORMATION_SCHEMA.COLUMNS 
where TABLE_NAME='yourTable';
</code></pre>

blocks|key|1725305|text|您还可以将结果(或前10个结果)插入到临时表中，并从临时表中获取列(只要列名都不同)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1725306|SELECT+TOP+10+*
INTO+#TempTable
FROM+<DataSource>|code-block|syntax|javascript|1725307|然后使用：|1725308|EXEC+tempdb.dbo.sp_help+N'#TempTable';|1725309|或|1725310|SELECT+*+
FROM+tempdb.sys.columns+
WHERE+[object_id]+=+OBJECT_ID(N'tempdb..#TempTable');|1725311|是从Aaron's+answer+here推断出来的。|offset|length|1725312|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/7486974/641833^0|0|0|0|0|0|0|2|J|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

You could also insert the results (or top 10 results) into a temp table and get the columns from the temp table (as long as the column names are all different).

<pre><code>SELECT TOP 10 *
INTO #TempTable
FROM &lt;DataSource&gt;
</code></pre>

Then use: 

<pre><code>EXEC tempdb.dbo.sp_help N'#TempTable';
</code></pre>

or

<pre><code>SELECT * 
FROM tempdb.sys.columns 
WHERE [object_id] = OBJECT_ID(N'tempdb..#TempTable');
</code></pre>

Extrapolated from <a href="https://stackoverflow.com/a/7486974/641833">Aaron's answer here</a>.

blocks|key|1723229|text|SELECT+COLUMN_NAME,
+++++++DATA_TYPE,
+++++++CHARACTER_MAXIMUM_LENGTH
FROM+information_schema.columns
WHERE+TABLE_NAME+=+'YOUR_TABLE_NAME'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1723230|您可以使用列别名来获得更好的输出效果。|unstyled|1723231|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT COLUMN_NAME,
 DATA_TYPE,
 CHARACTER_MAXIMUM_LENGTH
FROM information_schema.columns
WHERE TABLE_NAME = 'YOUR_TABLE_NAME'
</code></pre>

You can use columns aliases for better looking output.

blocks|key|316441|text|要做到这一点，一定是更简单的方法。低头看，这是...！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|316442|"sp_describe_first_result_set“是你的朋友！|offset|length|style|BOLD|316443|现在，我确实意识到这个问题是专门针对SQL+Server+2000提出的，但我正在为以后的版本寻找类似的解决方案，并发现SQL中的一些本机支持可以实现这一点。|316444|在SQL+Server+2012及更高版本中，请参阅"sp_describe_first_result_set“-+Link+to+BOL|316445|我已经使用与上面的@Trisped's类似的技术实现了一个解决方案，并将其删除以实现本机SQL+Server实现。|316446|如果你还没有使用SQL+Server+2012或Azure+SQL数据库，下面是我为2012年前的数据库创建的存储进程：|316447|CREATE+PROCEDURE+[fn].[GetQueryResultMetadata]+
++++@queryText+VARCHAR(MAX)
AS
BEGIN

++++--+SET+NOCOUNT+ON+added+to+prevent+extra+result+sets+from
++++--+interfering+with+SELECT+statements.
++++--SET+NOCOUNT+ON;

++++PRINT+@queryText;

++++DECLARE
++++++++++++++++@sqlToExec+NVARCHAR(MAX)+=+
++++++++++++++++++++'SELECT+TOP+1+*+INTO+#QueryMetadata+FROM+('
++++++++++++++++++++%2B
++++++++++++++++++++@queryText
++++++++++++++++++++%2B
++++++++++++++++++++')+T;'
++++++++++++++++++++%2B+'
++++++++++++++++++++++++SELECT
++++++++++++++++++++++++++++++++++++C.Name++++++++++++++++++++++++++[ColumnName],
++++++++++++++++++++++++++++++++++++TP.Name+++++++++++++++++++++++++[ColumnType],
++++++++++++++++++++++++++++++++++++C.max_length++++++++++++++++++++[MaxLength],
++++++++++++++++++++++++++++++++++++C.[precision]+++++++++++++++++++[Precision],
++++++++++++++++++++++++++++++++++++C.[scale]+++++++++++++++++++++++[Scale],
++++++++++++++++++++++++++++++++++++C.[is_nullable]+++++++++++++++++IsNullable
++++++++++++++++++++++++FROM
++++++++++++++++++++++++++++++++++++tempdb.sys.columns++++++++++++++C
++++++++++++++++++++++++++++++++++++++++INNER+JOIN
++++++++++++++++++++++++++++++++++++tempdb.sys.types++++++++++++++++TP
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ON
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++TP.system_type_id+=+C.system_type_id
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++AND
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--+exclude+custom+types
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++TP.system_type_id+=+TP.user_type_id
++++++++++++++++++++++++WHERE
++++++++++++++++++++++++++++++++++++[object_id]+=+OBJECT_ID(N''tempdb..#QueryMetadata'');
++++++++++++'

++++EXEC+sp_executesql+@sqlToExec

END|code-block|syntax|javascript|316448|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ff878602.aspx|1|https://stackoverflow.com/a/26067533/641833^0|0|1|S|0|0|1M|B|0|0|9|A|1|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|18|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|19|8|@]|9|@$D|1A|E|1B|1|1C]]|A|$]]|$1|L|3|M|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|N|3|O|5|6|7|1H|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1I|8|@]|9|@]|A|$S|T]]|$1|U|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|X|Y|Z|A|$10|13]]]]

There MUST be en easier way to do this... Low and behold, there is...!

"sp_describe_first_result_set" is your friend!

Now I do realise the question was asked specifically for SQL Server 2000, but I was looking for a similar solution for later versions and discovered some native support in SQL to achieve this.

In SQL Server 2012 onwards cf. "sp_describe_first_result_set" - <a href="https://msdn.microsoft.com/en-us/library/ff878602.aspx" rel="noreferrer">Link to BOL</a> 

I had already implemented a solution using a technique similar to <a href="https://stackoverflow.com/a/26067533/641833">@Trisped's</a> above and ripped it out to implement the native SQL Server implementation.

In case you're not on SQL Server 2012 or Azure SQL Database yet, here's the stored proc I created for pre-2012 era databases:

<pre><code>CREATE PROCEDURE [fn].[GetQueryResultMetadata] 
 @queryText VARCHAR(MAX)
AS
BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 --SET NOCOUNT ON;

 PRINT @queryText;

 DECLARE
 @sqlToExec NVARCHAR(MAX) = 
 'SELECT TOP 1 * INTO #QueryMetadata FROM ('
 +
 @queryText
 +
 ') T;'
 + '
 SELECT
 C.Name [ColumnName],
 TP.Name [ColumnType],
 C.max_length [MaxLength],
 C.[precision] [Precision],
 C.[scale] [Scale],
 C.[is_nullable] IsNullable
 FROM
 tempdb.sys.columns C
 INNER JOIN
 tempdb.sys.types TP
 ON
 TP.system_type_id = C.system_type_id
 AND
 -- exclude custom types
 TP.system_type_id = TP.user_type_id
 WHERE
 [object_id] = OBJECT_ID(N''tempdb..#QueryMetadata'');
 '

 EXEC sp_executesql @sqlToExec

END
</code></pre>

blocks|key|424782|text|这将为您提供与列属性相关的所有内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|424783|SELECT+*+INTO+TMP1
FROM+(+SELECT+TOP+1+/*+rest+of+your+query+expression+here+*/+);

SELECT+o.name+AS+obj_name,+TYPE_NAME(c.user_type_id)+AS+type_name,+c.*++
FROM+sys.objects+AS+o+++
JOIN+sys.columns+AS+c++ON+o.object_id+=+c.object_id++
WHERE+o.name+=+'TMP1';

DROP+TABLE+TMP1;|code-block|syntax|javascript|424784|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will give you everything column property related.

<pre><code>SELECT * INTO TMP1
FROM ( SELECT TOP 1 /* rest of your query expression here */ );

SELECT o.name AS obj_name, TYPE_NAME(c.user_type_id) AS type_name, c.* 
FROM sys.objects AS o 
JOIN sys.columns AS c ON o.object_id = c.object_id 
WHERE o.name = 'TMP1';

DROP TABLE TMP1;
</code></pre>

blocks|key|1723320|text|对于SQL+Server+2012及更高版本:如果将查询放入字符串中，则可以获得如下结果集数据类型：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1723321|DECLARE+@query+nvarchar(max)+=+'select+12.1+/+10.1+AS+[Column1]';
EXEC+sp_describe_first_result_set+@query,+null,+0;++|code-block|syntax|javascript|1723322|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For SQL Server 2012 and above: If you place the query into a string then you can get the result set data types like so:

<pre><code>DECLARE @query nvarchar(max) = 'select 12.1 / 10.1 AS [Column1]';
EXEC sp_describe_first_result_set @query, null, 0; 
</code></pre>

blocks|key|1725379|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1725380|+sp_describe_first_result_set|blockquote|1725381|1725382|1725383|将有助于通过分析第一个查询结果集的数据类型来识别查询的数据类型|1725384|https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql?view=sql-server-2017|offset|length|1725385|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|41|0|0^^$0|@$1|2|3|-4|4|5|6|S|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|T|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|U|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|V|7|@]|8|@]|9|$]]|$1|F|3|G|4|5|6|W|7|@]|8|@]|9|$]]|$1|H|3|I|4|5|6|X|7|@]|8|@$J|Y|K|Z|1|10]]|9|$]]|$1|L|3|-4|4|5|6|11|7|@]|8|@]|9|$]]]|M|$N|$4|O|P|Q|9|$R|I]]]]

<blockquote>
 sp_describe_first_result_set
</blockquote>

will help to identify the datatypes of query by analyzing datatypes of first resultset of query

<a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql?view=sql-server-2017</a>

blocks|key|1723410|text|我使用一个简单的case语句来呈现我可以在技术规范文档中使用的结果。这个例子没有包含你在数据库中遇到的所有条件，但是它为你提供了一个很好的模板。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1723411|SELECT
+++++TABLE_NAME++++++++++AS+'Table+Name',
+++++COLUMN_NAME+++++++++AS+'Column+Name',
+++++CASE+WHEN+DATA_TYPE+LIKE+'%25char'
++++++++++THEN+DATA_TYPE+%2B+'('+%2B+CONVERT(VARCHAR,+CHARACTER_MAXIMUM_LENGTH)+%2B+')'
++++++++++WHEN+DATA_TYPE+IN+('bit',+'int',+'smallint',+'date')
++++++++++THEN+DATA_TYPE
++++++++++WHEN+DATA_TYPE+=+'datetime'
++++++++++THEN+DATA_TYPE+%2B+'('+%2B+CONVERT(VARCHAR,+DATETIME_PRECISION)+%2B+')'
++++++++++WHEN+DATA_TYPE+=+'float'
++++++++++THEN+DATA_TYPE
++++++++++WHEN+DATA_TYPE+IN+('numeric',+'money')
++++++++++THEN+DATA_TYPE+%2B+'('+%2B+CONVERT(VARCHAR,+NUMERIC_PRECISION)+%2B+',+'+%2B+CONVERT(VARCHAR,+NUMERIC_PRECISION_RADIX)+%2B+')'
+++++END+++++++++++++++++AS+'Data+Type',
+++++CASE+WHEN+IS_NULLABLE+=+'NO'
++++++++++THEN+'NOT+NULL'
++++++++++ELSE+'NULL'
+++++END+++++++++++++++++AS+'PK/LK/NOT+NULL'
FROM+INFORMATION_SCHEMA.COLUMNS+
ORDER+BY+
+++++TABLE_NAME,+ORDINAL_POSITION|code-block|syntax|javascript|1723412|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I use a simple case statement to render results I can use in technical specification documents. This example does not contain every condition you will run into with a database, but it gives you a good template to work with.

<pre><code>SELECT
 TABLE_NAME AS 'Table Name',
 COLUMN_NAME AS 'Column Name',
 CASE WHEN DATA_TYPE LIKE '%char'
 THEN DATA_TYPE + '(' + CONVERT(VARCHAR, CHARACTER_MAXIMUM_LENGTH) + ')'
 WHEN DATA_TYPE IN ('bit', 'int', 'smallint', 'date')
 THEN DATA_TYPE
 WHEN DATA_TYPE = 'datetime'
 THEN DATA_TYPE + '(' + CONVERT(VARCHAR, DATETIME_PRECISION) + ')'
 WHEN DATA_TYPE = 'float'
 THEN DATA_TYPE
 WHEN DATA_TYPE IN ('numeric', 'money')
 THEN DATA_TYPE + '(' + CONVERT(VARCHAR, NUMERIC_PRECISION) + ', ' + CONVERT(VARCHAR, NUMERIC_PRECISION_RADIX) + ')'
 END AS 'Data Type',
 CASE WHEN IS_NULLABLE = 'NO'
 THEN 'NOT NULL'
 ELSE 'NULL'
 END AS 'PK/LK/NOT NULL'
FROM INFORMATION_SCHEMA.COLUMNS 
ORDER BY 
 TABLE_NAME, ORDINAL_POSITION
</code></pre>

blocks|key|316639|text|这个简单的查询返回一个数据类型位。您可以将此thecnic用于其他数据类型：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|316640|选择CAST(0+AS+BIT)+AS+OK+(转换(0作为位))|316641|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This easy query return a data type bit. You can use this thecnic for other data types:

select CAST(0 AS BIT) AS OK

blocks|key|1723700|text|检查数据类型。检查SQL+Server数据库数据类型的第一种方法是使用SYS架构表进行查询。下面的查询使用列和类型表：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1723701|++++SELECT+C.NAME+AS+COLUMN_NAME,
+++++++TYPE_NAME(C.USER_TYPE_ID)+AS+DATA_TYPE,
+++++++C.IS_NULLABLE,
+++++++C.MAX_LENGTH,
+++++++C.PRECISION,
+++++++C.SCALE
FROM+SYS.COLUMNS+C
JOIN+SYS.TYPES+T
+++++ON+C.USER_TYPE_ID=T.USER_TYPE_ID
WHERE+C.OBJECT_ID=OBJECT_ID('your_table_name');|code-block|syntax|javascript|1723702|通过这种方式，您可以找到列的数据类型。|1723703|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Checking data types.
The first way to check data types for SQL Server database is a query with the SYS schema table. The below query uses COLUMNS and TYPES tables:
<pre><code> SELECT C.NAME AS COLUMN_NAME,
 TYPE_NAME(C.USER_TYPE_ID) AS DATA_TYPE,
 C.IS_NULLABLE,
 C.MAX_LENGTH,
 C.PRECISION,
 C.SCALE
FROM SYS.COLUMNS C
JOIN SYS.TYPES T
 ON C.USER_TYPE_ID=T.USER_TYPE_ID
WHERE C.OBJECT_ID=OBJECT_ID('your_table_name');
</code></pre>
In this way, you can find data types of columns.

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.

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:

<pre><code>SELECT Auth_First_Name, Auth_Last_Name, Auth_Favorite_Number 
FROM Authors
</code></pre>

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

<pre><code>Auth_First_Name is char(25)
Auth_Last_Name is char(50)
Auth_Favorite_Number is int
</code></pre>

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

How do I return the SQL data types from my query?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个SQL查询，它查询一个我既不需要也不想理解的庞大数据库(例如，数百个带有难以阅读的名称的视图/表，如CMM-CPP-FAP-ADD)。此查询的结果需要存储在临时表中，以便提供报告。我需要创建临时表，但由于要挖掘数百个视图/表来查找这里所表示的数据类型，我不得不怀疑是否有更好的方法来构造这个表。有人能告诉我如何使...

问如何从查询中返回SQL数据类型？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从查询中返回SQL数据类型？EN