Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using xp_create_subdir to Create Windows Folders with SQL

Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.


advertisement

Did you know that you can create Folders with T-SQL? With the help of the built-in Extended Stored Procedure named xp_create_subdir you can. Here is a small example:

DECLARE @DBName nvarchar(100)
DECLARE @Folder nvarchar(100)
SET @DBName = 'TestDB'
SET @Folder = 'C:\TestFolder\' + @DBName
EXEC master.dbo.xp_create_subdir @Folder

It goes without saying that you need to ensure that the correct permissions are set up in your SQL environment.



   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date