Snipplr

(SQL) Search Stored Prcedures Code - dmilligan

Thu, 27 Dec 2012 07:35:39 GMT

Search the source code of all stored procedures.

(SQL) Last modified - hojgaard

Thu, 23 Feb 2012 20:01:21 GMT

Lists when tables, stored procedure, views and functions where last modified. Shows only modified items within the last 14 days.

(VB.NET) DataReader code block - delineo

Fri, 12 Nov 2010 21:22:29 GMT

(MySQL) Working with spatial extension - lucien144

Thu, 19 Aug 2010 17:08:09 GMT

In this snippet we have one table with GPS points of Queensland (Australia) borders and table of polygons. One of the polygons are created from QLD points by procedure **createPolygon**. Function **checkCoordinatesInPolygon** can check whether GPS coordinates are within some polygon or not.

(MySQL) Nested loop with cursor in procedure - lucien144

Thu, 19 Aug 2010 16:59:13 GMT

This snippet just showing how to make nested loops with cursors in MySQL.

(SQL) Search Stored Procedure for String - CDIDevs

Thu, 31 Dec 2009 11:03:00 GMT

(SQL) List all Stored Procs in Database - CDIDevs

Thu, 31 Dec 2009 10:53:41 GMT

(Scheme) scheme: check for optional arguments - magicrebirth

Sat, 12 Dec 2009 18:05:02 GMT

(SQL) Create a Temporary table within a SQL Stored Procedure - highlyevolved

Fri, 06 Nov 2009 11:12:51 GMT

A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table. Don't forget to Drop the table after the SELECT * FROM #TempTableName at the end.

(SQL) Search stored procedures for string - charmcitycoder

Mon, 27 Jul 2009 15:37:23 GMT

(SQL) Search through stored procs - hobeau

Tue, 21 Apr 2009 13:55:14 GMT

search for text in your stored procedure

(Rails) Freeze a gem with GemsOnRails - noah

Tue, 09 Dec 2008 12:36:45 GMT

On Mac OS 10.5, these are all the commands to install GemsOnRails, freeze the Compass gem and add everything into subversion. The output of each command (on my machine anyway) is also shown.

(C#) Database Retrieve - lfbarbieri

Wed, 09 May 2007 15:24:44 GMT

(SQL) SQLServer 2000 T-SQL Stored Procedure for providing paginated results - planetthoughtful

Fri, 30 Jun 2006 00:44:38 GMT

Example usage: exec sp_easypaging '[tblmessages]','[tblmessages].recid','','*','1 = 1','recid',1,5