Gjoreski |
07.09.2021 12:52 |
Predmet:Kreirajne Direktorium (Folder)
PreuzmiIzvorni kôd (SQL):-- =============================================
-- Author: <Gjoreski Aleksandar>
-- Create date: <09.07.2021 13:42:21>
-- Description: <Stored Procedura za kreirajne na direktoriom (Folder) >
-- =============================================
ALTER PROCEDURE [dbo].[spCreate_FTP_Folder]
( @Folder AS NVARCHAR(30))
AS
BEGIN
SET @Folder='MD C:\FTP_Doc\' + CONVERT(NVARCHAR,@Folder)
EXEC sp_configure 'xp_cmdshell', '1'
RECONFIGURE
EXEC xp_cmdshell @Folder
EXEC sp_configure 'xp_cmdshell', '0'
RECONFIGURE
END
|