http://snipplr.com/tags/sql Recent snippets posted on Snipplr.com en-us Sun, 06 Jul 2008 03:21:38 GMT http://snipplr.com/view/6492/multiple-inserts/

]]> Thu, 29 May 2008 09:50:41 GMT http://snipplr.com/view/6492/multiple-inserts/ http://snipplr.com/view/6456/vbs-datenbankzugriff/

]]> Mon, 26 May 2008 02:21:39 GMT http://snipplr.com/view/6456/vbs-datenbankzugriff/ http://snipplr.com/view/6448/match-merge-using-proc-sql/

]]> Sat, 24 May 2008 18:44:21 GMT http://snipplr.com/view/6448/match-merge-using-proc-sql/ http://snipplr.com/view/6367/commadelimited-list-using-coalesce/ If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

]]> Tue, 20 May 2008 17:50:43 GMT http://snipplr.com/view/6367/commadelimited-list-using-coalesce/ http://snipplr.com/view/6289/postgres-output-csv/

]]> Mon, 19 May 2008 06:20:17 GMT http://snipplr.com/view/6289/postgres-output-csv/ http://snipplr.com/view/6115/simple-oracle-trigger/

]]> Mon, 05 May 2008 11:00:42 GMT http://snipplr.com/view/6115/simple-oracle-trigger/ http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ Using Proc SQL summarize the table sashelp.shoes grouping on

]]> Sat, 03 May 2008 15:19:18 GMT http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ http://snipplr.com/view/5861/django-dump-sql-data-into-an-xml-file/

]]> Tue, 15 Apr 2008 04:45:03 GMT http://snipplr.com/view/5861/django-dump-sql-data-into-an-xml-file/ http://snipplr.com/view/5695/grant-mysql-privileges/ To grant all privileges to a user from any location login to the mysql shell and run the following queries.

]]> Fri, 04 Apr 2008 03:52:39 GMT http://snipplr.com/view/5695/grant-mysql-privileges/ http://snipplr.com/view/5694/set-mysql-root-password/ To reset the MySQL root password, login to the mysql shell and run the following commands.

]]> Fri, 04 Apr 2008 03:48:37 GMT http://snipplr.com/view/5694/set-mysql-root-password/ http://snipplr.com/view/5647/logical-expressions-in-sql/

]]> Tue, 01 Apr 2008 13:39:05 GMT http://snipplr.com/view/5647/logical-expressions-in-sql/ http://snipplr.com/view/5567/simple-oracle-stored-procedure/ Just a template...

]]> Wed, 26 Mar 2008 06:51:42 GMT http://snipplr.com/view/5567/simple-oracle-stored-procedure/ http://snipplr.com/view/5549/aspnet-page-to-return-an-image-from-an-sql-blob-query/

]]> Mon, 24 Mar 2008 21:36:37 GMT http://snipplr.com/view/5549/aspnet-page-to-return-an-image-from-an-sql-blob-query/ http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/

]]> Mon, 24 Mar 2008 18:00:18 GMT http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/ http://snipplr.com/view/5514/utility-php-function-to-paginate-sql-queries/

]]> Thu, 20 Mar 2008 20:33:32 GMT http://snipplr.com/view/5514/utility-php-function-to-paginate-sql-queries/ http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/

]]> Wed, 19 Mar 2008 22:55:37 GMT http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/ http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/

]]> Wed, 19 Mar 2008 22:54:33 GMT http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/ http://snipplr.com/view/5331/php-escape-for-sql/

]]> Sun, 09 Mar 2008 01:27:06 GMT http://snipplr.com/view/5331/php-escape-for-sql/ http://snipplr.com/view/5208/sql-mysql-csv/

]]> Tue, 26 Feb 2008 20:13:52 GMT http://snipplr.com/view/5208/sql-mysql-csv/ http://snipplr.com/view/5207/sql-csv-mysql/

]]> Tue, 26 Feb 2008 20:12:59 GMT http://snipplr.com/view/5207/sql-csv-mysql/