TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 51, comments - 60, trackbacks - 14

Quick Tips

Quick & short tips for command-line tools
Quick Tip #1: Using the for command to get directory info

Sometimes I need to import file information into SQL Server, or just get a list of files, sizes, etc. Normally I use the dir command, but it generates a fixed layout that is sometimes difficult to parse. Here's an easier way to get file name, size, and date in a comma-delimited format: for %a in (*.*) do @echo %a,%~za,%~ta...or...for %a in (*.*) do @echo %a,%~za,%~tam Depending on which version of Windows you're running, you may prefer the 2nd version, it will add an "m" to the time display so that times show as "AM" or "PM". Windows 2003 would use the...

posted @ Wednesday, February 02, 2005 10:35 PM | Feedback (3) |

Powered by:
Powered By Subtext Powered By ASP.NET