de exemplu asta imi creaza un file......cum pot modifica sa-mi creeze un folder?
create proc _NewFolder
@FolderTEST nvarchar(25)
as
DECLARE
@cmd sysname,
@destinatie nvarchar(50)
set @destinatie='D:\'+@FolderTEST
SET @cmd = 'echo ' + ' > '+@destinatie
EXEC master..xp_cmdshell @cmd
GO