摘要:
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 阅读全文