Is there an open source repository for SQL code?

Tags:

sql

I find myself writing SQL code (queries or stored procs) to solve problems that can definitely be defined as 'patterns' that occur frequently in business.

Rather than having to wrack my brain each time I encounter a new problem (which must have been solved a countless times by other coders/db analysts, I wondered if there was a repository I could go to check out (peer reviewed) code - and maybe add my two pence every now and then. I know different db vendors tend to write slightly variant forms of SQL - but there could still be a repository with ANSI stuff and proprietary stuff. Hopefully, such a site would encourage more people to write standardized SQL.

Is there such a site?. If no - why not? (would anyone else be interested in such a site?) If such a site exists, please provide link(s), as Google is not finding anything remotely useful.

290

asked Jun 04 '10 06:06

morpheous

2 Answers

Snipplr is a user-contributed repository for SQL snippets as well as other code snippets for many other languages.

answered Oct 14 '22 01:10

anonymous

There is the site SQL Examples.

answered Oct 14 '22 02:10

Bozhidar Batsov

Related questions
                            
                                Any good SQL Anywhere database schema comparison tools?
                            
                                While-clause in T-SQL that loops forever
                            
                                LINQ COUNT on multiple columns
                            
                                SQL produced by Entity Framework for string matching
                            
                                MySQL Fulltext index with Rails 2.3.2 (migration problem)
                            
                                Get the SUM of TIME datatypes (MSSQL08) from a table
                            
                                Handling nulls in Datawarehouse
                            
                                SQL Query to Select Everything Except the Max Value
                            
                                Multiple Row_Number() Calls in a Single SQL Query
                            
                                Database design for custom form builder (and storage of results)
                            
                                Transfer MySQL to SQLite
                            
                                I'm using SQL UDF's to encapsulate simple reporting/business logic. Should I avoid this?
                            
                                MySQL Split to use in "SELECT WHERE IN" statement
                            
                                Oracle 10g - Write queries results to file
                            
                                Which Tool can generate UML by SQL? [closed]
                            
                                COUNT() Function in conjunction with NOT IN clause not working properly with varchar field (T-SQL)
                            
                                How to load 1 milion records from database fast?
                            
                                SQL - .NET - SqlParameters - AddWithValue - Are there any negative performance implications when Param Type is not specified?
                            
                                SQL Exception: A truncation error was encountered trying to shrink VARCHAR '...' to length x
                            
                                Free tool to watch database for changes?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With