Aug 8, 2010

DOS command in T-sql (xp_cmdshell)

EXEC master..xp_cmdshell 'dir c:'
EXEC master..xp_cmdshell 'RENAME E:\"HR Reports"\"Master Sheet"*.xls "Master Sheet".xls'

No comments: