SELECT COLUMN_NAME,ORDINAL_POSITION, DATA_TYPE INTO #TEMP FROM INFORMATION_SCHEMA.COLUMNS AS C --此语句得出指定表的字段名及相应的数据类型 Left JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'products','column', default) AS E ON C.COLUMN_NAME = E.objname WHERE TABLE_NAME = 'products'
同意westbulls(westbulls) select * into #t from tablename 其中t为名称,务必要加上#标志,此表只能在过程内存在!看不到:) 用完之后drop table #t
Left JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'products','column', default) AS E
ON C.COLUMN_NAME = E.objname
WHERE TABLE_NAME = 'products'
select * into #t from tablename
其中t为名称,务必要加上#标志,此表只能在过程内存在!看不到:)
用完之后drop table #t