摘要: CREATE TABLE #result ( id INT IDENTITY(1, 1) , objectid INT , scemaid INT , NAME VARCHAR(300) )INSERT INTO #result ( objectid , scemaid , NAME ) SELECT object_id , schema_id , name FROM sys.objects WHERE schema_id = 6 AND type = 'P'CREATE TABLE #result2 ( id INT IDENTITY(1, 1) , objectid INT 阅读全文
posted @ 2012-09-04 10:40 scott.pei 阅读(169) 评论(0) 推荐(0) 编辑