取数据库字段信息
摘要：
create procedure [dbo].[proGetColumnInfo] @tblName nvarchar(50) asselect table_name=c.Name, col_name=a.Name, is_identity, is_primary=case when exists(select 1 from sys.objects INNER JOIN sys.indexes ON sys.indexes.Name=sys.objects.Name INNER JOIN sysindexkeys ON sysindexkeys.indid=sys.indexes.index_ 阅读全文
posted @ 2011-05-24 09:31 笑看风云淡 阅读(149) 评论(0) 推荐(0) 编辑
