directory (1) 썸네일형 리스트형 Create Directory SQL --USE Master; --GO SET NOCOUNT ON -- 1 - Variable declaration DECLARE @DBName sysname DECLARE @DataPath nvarchar(500) DECLARE @LogPath nvarchar(500) DECLARE @DirTree TABLE (subdirectory nvarchar(255), depth INT) -- 2 - Initialize variables SET @DBName = 'Pubs' SET @DataPath = 'C:\Test1\' + @DBName SET @LogPath = 'C:\Test2\' + @DBName -- 3 - @DataPath values INSERT INTO @DirTree(subdirectory, dep.. 이전 1 다음