SQL Server查询数据库字段信息
摘要:以下代码兼容SQL Server 2000。 SELECT c.[name] AS '列名', CASE WHEN t.[name] = 'DECIMAL' OR t.[name] = 'NUMERIC' THEN UPPER(t.[name]) + '(' + CAST(c.[xprec] AS VARCHAR) + ', ' + CAST(c.[xscale] AS VARCHAR) + ')...
阅读全文
posted @ 2010-05-06 11:40