Create a new folder in TSQL

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  November 18, 2008 at 2:52 am

  #72254

  Hi i'd like to create a new folder in TSQL the folder name should look like WK##

  where ## is the week number.

  The week number will change each week. I'd like this to be part of a stored procedure..

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  November 18, 2008 at 3:05 am

  #899740

  Hi

  You will have to extended procedures for this. Check out these extended procedures on the net

  xp_create_subdir ,xp_dirtree.

  "Keep Trying"

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  November 18, 2008 at 3:19 am

  #899748

  sql_Reporter (11/18/2008)

  ---

  Hi i'd like to create a new folder in TSQL the folder name should look like WK##

  where ## is the week number.

  The week number will change each week. I'd like this to be part of a stored procedure..

  use xp_cmdshell command you can create folders. for more info. see SQL BOL.

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  November 18, 2008 at 4:24 am

  #899774

  Here is my try at this, the code runs ok but it does not create a folder for me ?

  Any ideas

  declare @md varchar(100), @Path varchar(100),@wk_novarchar(2)

  set@wk_no = datepart(wk,getdate())

  --print @wk_no

  SET@Path = 'E:\temp\'

  SET@md ='mkdir' + @Path +'WK' + @wk_no

  EXECxp_cmdshell@md, no_output

  PRINT@md

• Lester Policarpio

  SSCertifiable

  Points: 7109

  More actions

  November 18, 2008 at 9:22 pm

  #900276

  sql_Reporter (11/18/2008)

  ---

  Here is my try at this, the code runs ok but it does not create a folder for me ?

  Any ideas

  declare @md varchar(100), @Path varchar(100),@wk_novarchar(2)

  set@wk_no = datepart(wk,getdate())

  --print @wk_no

  SET@Path = 'E:\temp\'

  SET@md =' mkdir ' + @Path +'WK' + @wk_no

  EXECxp_cmdshell@md, no_output

  PRINT@md

  Your script is correct just put spaces on the left and right of the 'mkdir' (see bolded part above). The command you generated if you print it is mkdirE:\temp\MK47 the command shell doesn't recognize the mkdir command.

  "-=Still Learning=-"

  Lester Policarpio