Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 Just in case someone needs this

Author  Topic 

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-14 : 05:15:20
Ever had a list of stored procedures in .sql or .prc files in a directory and wanted to merge them all into one?
try in dos prompt: type *.* > AllSql.sql

Saves writing a loop to do it!

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-07-14 : 07:07:15
That is very nice bob!

Make sure You check out Rob's blog, he has a section on DOS stuff, really neat!
http://weblogs.sqlteam.com/robv/category/122.aspx

rockmoose
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-07-14 : 07:22:25
An old faithful that trick. Helped me out a bunch of times

And yes, Rob is the master


Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page
   

- Advertisement -