What do you use for organizing SQL snippets?

views:

204

answers:

+1 Q:

What do you use for organizing SQL snippets?

I've been using a directory structure with separate SQL files. I work as an consultant and the customer wants some of their people to have an "easier" interface for organizing/searching for SQL snippets than directories and operating system search.

What solutions are others using? Seems like there would be some FOSS already out there for this.

Thanks

Well in SQL Server you can save templates and then access them directly in Management Studio.

HLGEM 2009-12-11 14:47:15

have you found a good way to use this? My experience is that the directory where SQL Studio stores templates is hard coded and not configureable? Id like to point it to one ore more directories, but now instead i have to copy my snippets into the location MS think they should be :-(Not optimal for team development, source management, etc..

Brimstedt 2009-12-11 14:59:34

+1 A:

I've used gforge - it has a reasonably good facility for documenting snippets.

But I also use a wiki for this. And the wiki probably works better since it's easier to expand it for more comprehensive sets of pages dedicated to a given topic. But the contributors have to be better disciplined when adding content (no automatic formatting & tagging).

KenFar 2009-12-11 14:49:07

i use the free SSMS Tools Pack add in for SSMS. It has SQL snippet functionality built in.

Mladen Prajdic 2009-12-11 14:50:38

@Mladen looks like a nice free SSMS add-in. Like the connection coloring and explain plan to image feature, saves some mouse clicks in screen capturing. snippet-wise SSMS Templates looks nicer.

Chad 2009-12-11 15:25:57

ansaurus

tags:

views:

answers:

What do you use for organizing SQL snippets?

related questions