宣傳貼紙
除了 Download Day 網站上的貼紙之外,這邊我們也再度請出前年轟動武林的 MozTW 小狐狸 -- 狐耳摩莎登場,化身為正體中文特製貼紙,看官請慢用!
use master
SELECT clmns.name AS [Name],
usrt.name AS [DataType],
ISNULL(baset.name, N'') AS [SystemType],
CAST(CASE WHEN baset.name IN (N'nchar',N'nvarchar') AND clmns.max_length <> -1 THEN clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length],
CAST(clmns.precision AS int) AS [NumericPrecision],
CAST(clmns.scale AS int) AS [NumericScale],
clmns.is_nullable AS [Nullable],
clmns.is_computed AS [Computed]
FROM sys.tables AS tbl
INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id
LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id
LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = clmns.system_type_id
and baset.user_type_id = baset.system_type_id
WHERE (tbl.name=N'spt_values' and SCHEMA_NAME(tbl.schema_id)=N'dbo')
ORDER BY clmns.column_id ASC