Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

« Prev 1 ... 13 14 15 16 17 Next »

Perl MySQL based functions

0 1257 posted 17 years ago by eszpee

C# String Validation for Sqlinjection

1 1456 posted 17 years ago by jags_sonawane

SQL Differences between two Tables

1 1654 posted 18 years ago by zingo

SQL Copy table into a new table

0 1248 posted 18 years ago by Caliban

SQL Generate the SQL necessary to create triggers (Oracle)

Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with â€˜tblâ€™. It may need to be modified to work with different naming conventions.

0 1347 posted 18 years ago by thecrumb

SQL Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create sequences for every table. NOTE: This doesnâ€™t create sequences. The results need to be copied and run as a script.

0 1664 posted 18 years ago by thecrumb

SQL Get a list of all the user tables (Oracle)

Get a list of all the user tables.

0 1860 posted 18 years ago by thecrumb

SQL Get Columns and Comments (Oracle)

Get all my columns and comments.

0 1323 posted 18 years ago by thecrumb

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

0 1323 posted 18 years ago by rengber

SQL Move inactive Joomla 1.0 modules to the bottom of the modules list

Small query to help you relocate those modules you are not using anyways.

2 1648 posted 18 years ago by torkil

PHP Prevent SQL Injection

Pass a user-inputted variable to this function in order to prevent SQL injection. Example: mysql_query("INSERT INTO table VALUES('" . sql_sanitize($_POST["variable") . "')"); Instead of: mysql_query("INSERT INTO table VALUES('" . $_POST["var...

34 11664 posted 18 years ago by engel

Ruby Ruby One-liner for Restoring One Table from a Huge SQL Dump

Courtesy of Jesse.

2 1878 posted 18 years ago by ches

PHP clean user input data ( GET, POST, COOKIE )

Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)

31 7939 posted 18 years ago by peteypablonz

SQL Ordering multiple SELECT statements in a UNION

0 1597 posted 18 years ago by andyhartleeds

SQL Reset auto increment on a table

If you are deleting all the rows in a table and you also want to reset the values that will get used by auto increment, this is how to do it.

0 1597 posted 18 years ago by jachin

SQL Generate Simple Bar Charts From a MySQL Prompt

You can generate a simple bar chart of the values by executing this command...

0 1508 posted 18 years ago by zingo

Bash Import an .sql file

2 1187 posted 18 years ago by hyperwhat

SQL List all Stored Procedures in an Oracle Database

0 7240 posted 18 years ago by rengber

SQL Using a BitMask in a Where Clause

0 1315 posted 18 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1375 posted 18 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 1829 posted 18 years ago by rengber

C# Database Retrieve

0 1179 posted 18 years ago by lfbarbieri

SQL Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

0 1977 posted 18 years ago by rengber

C# Get the Return Value from an SQL Stored Procedure

0 2233 posted 18 years ago by rengber

Other Database access - table creation

0 1272 posted 18 years ago by ryanprel

PHP Get HTML list of Array Keys

1 1587 posted 18 years ago by drwitt

PHP PHP - Limpiar inyecciÃ³n sql

1 1315 posted 19 years ago by nicolaspar

PHP SELECT with conditional WHERE parts

Building a SELECT with conditional WHERE parts, given from form-get parameters.

1 1361 posted 19 years ago by assbach

C# SQL Stored Proc to Generate a list of C# constants representing data field names.

0 1729 posted 19 years ago by rengber

SQL MySQL error reporting

1 1391 posted 19 years ago by Shpigford