One of my blog reader requested that, how to create the directory using Script/SSMS. Here is the answer.
— Below query will list out the directories on C drive
EXEC MASTER.sys.Xp_dirtree ‘C:\JugalA’
— Below query will create the folder JugalA on C drive
EXEC MASTER.dbo.Xp_create_subdir ‘C:\JugalA’
— Below query will create the folder JugalB on C:\JugalA drive
EXEC MASTER.dbo.Xp_create_subdir ‘C:\JugalA\JugalB’
Advertisements
hi i am new with mysql ,. your codes are working fine with sqlserver but not with mysql
regards
rishav
hi rishav, mysql and mssql transact sql statements are different.
how to find directory is exists or not
Use xp_fileexist extended stored procedure for that