摘要:
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO--此存储过程主要用来导出表的相关结构CREATE PROCEDURE Get_TableInfo(@TableName nvarchar(250))ASSELECT CAST(a.name AS nvarchar(250)) fieldname, CAST((case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√' else '×' end) AS nvarchar(250) 阅读全文