[extract SP list] extract stored procedure list to html format #SP #extract #list
/* SP추출 */ --변수 DECLARE @SqlVersion AS CHAR(4) DECLARE @maxi AS INT , @maxj AS INT DECLARE @i AS INT , @j AS INT DECLARE @Output VARCHAR(4000),@description VARCHAR(4000) CREATE TABLE #Tables (id int identity(1, 1), Object_id int, name varchar(155), type varchar(20), [definition] varchar(MAX)) CREATE TABLE #Parameters (id int identity(1,1), name varchar(155), type Varchar(155)) --SQL 버전뽑기 IF (sub..
2022. 6. 14.