Remove Directory

Posted on By David Kittell 
rd c:\temp\directorytoremove

Now if this first command doesn’t work make sure it’s a directory you want to delete and try this next one

rd /s c:\temp\directorytoremove
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Windows Batch

Related Posts

MSSQL Format U.S. Phone Number

Posted on

SELECT CASE LEN(phone) WHEN 11 THEN LEFT(phone, 1) + STUFF(STUFF(STUFF(phone, 1, 1, ‘ (‘), 6, 0, ‘) ‘), 11, 0, ‘-‘) WHEN 10 THEN STUFF(STUFF(STUFF(phone, 1, 0, ‘ (‘), 6, 0, ‘) ‘), 11, 0, ‘-‘) WHEN 7 THEN STUFF(phone, 4, 0, ‘-‘) ELSE ‘Invalid phone’ END AS ‘Formatted Phone’…

Read More

MSSQL – Valid Date

Posted on

Validate a non-DateTime data type field is a really a date. SET LANGUAGE English; — Not necessary but can be helpful SELECT ISDATE(’15/04/2008′); –Returns 0. SELECT ISDATE(’04/15/2008′); –Returns 1. Originally Posted on March 14, 2014Last Updated on October 26, 2015 All information on this site is shared with the intention…

Read More

MSSQL – Table/View Column Information

Posted on

Similar to MySQL – Table/View Column Information, this post will help with MSSQL tables and columns. exec sp_columns ‘<tablename>’ Cleaner Result: SET NOCOUNT ON DECLARE @tablename NVARCHAR(max) SET @tablename = <tablename> SELECT c.NAME ‘Column Name’ ,t.NAME ‘Data type’ ,c.max_length ‘Max Length’ , –c.precision , –c.scale , CASE c.is_nullable WHEN 0…

Read More