Prikazi cijelu temu 07.09.2021 11:52
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Kreirajne Direktorium (Folder)
PreuzmiIzvorni kôd (SQL):
  1. -- =============================================
  2. -- Author:              <Gjoreski Aleksandar>
  3. -- Create date: <09.07.2021 13:42:21>
  4. -- Description: <Stored Procedura za kreirajne na direktoriom (Folder) >
  5. -- =============================================
  6. ALTER PROCEDURE [dbo].[spCreate_FTP_Folder]
  7.          ( @Folder AS NVARCHAR(30))
  8. AS
  9. BEGIN
  10.         SET @Folder='MD C:\FTP_Doc\' + CONVERT(NVARCHAR,@Folder)
  11.        EXEC sp_configure 'xp_cmdshell', '1'
  12.        RECONFIGURE
  13.        EXEC xp_cmdshell @Folder
  14.        EXEC sp_configure 'xp_cmdshell', '0'
  15.        RECONFIGURE
  16.  
  17. END