摘要: 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) 阅读全文
posted @ 2007-05-17 09:34 spring3 阅读(134) 评论(0) 推荐(0) 编辑