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 ... 11 12 13 14 15 16 17 Next »

SQL Re-seed Identity Table

Re-seed identity table if rows were deleted/there are gaps in numerical order

2 1662 posted 16 years ago by CDIDevs

SQL Script table as INSERTS

1 2053 posted 16 years ago by CDIDevs

SQL Search Database for string

2 1725 posted 16 years ago by CDIDevs

SQL Search Database for Column Name

1 1607 posted 16 years ago by CDIDevs

MySQL Starting and stopping MySQL

1 1432 posted 16 years ago by magicrebirth

C# Pagination in SQL

Call it in the button click event after in(de)crementing CurrentPage value

0 1383 posted 16 years ago by tomaszsimon

SQL Calculating distance in Kilometres and Miles from Latitude and Longitude

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

3 2692 posted 16 years ago by zingo

SQL Joomla admin password reset

Reset joomla super admin password to â€adminâ€œ

1 1569 posted 16 years ago by elisium

MySQL Reset Auto Increment for a Table

0 1814 posted 16 years ago by kingkool68

SQL Create a Temporary table within a SQL Stored Procedure

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.

2 2357 posted 16 years ago by highlyevolved

SQL Convert Date/Time in SQL

These statements convert a date/time field into just a date or a time field

2 2208 posted 16 years ago by highlyevolved

PHP mysql_safe_query to prevent SQL injection

3 2576 posted 16 years ago by jmiller

SQL Get Plesk FTP account passwords w/o logging into MySQL

0 1581 posted 16 years ago by tobewan

SQL Grab Plesk FTP account passwords

0 1536 posted 16 years ago by tobewan

Bash Grab Plesk domain passwords

0 1400 posted 16 years ago by tobewan

SQL Delete All Foreign Keys

Delete All Foreign Keys in a database; (make sure you USE keyword)

2 1547 posted 16 years ago by marcocs

Rails DISTINCT in Rails

0 1815 posted 16 years ago by almazom

PHP Sanitize a PHP string for input into a Database

2 2408 posted 16 years ago by adamcoulombe

PHP Normalize telephone numbers

This snippet is usable for telephone number normalization. It supports re-mapping of misused alphabetical characters (e.g. i for 1) and some other clean up stuff... Take a look. Update, 2009-10-02: added function to create a corresponding MySQL RE...

1 1920 posted 16 years ago by dreadwarrior

SQL Create New User and Grant

1 1645 posted 16 years ago by wearetherock

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

1 2341 posted 16 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 2046 posted 16 years ago by rengber

Python Copy a table from one database to another

0 4188 posted 16 years ago by bingjian

PHP Basic script for prevert SQL inj and XSS

Function for sanitize input POST, GET, COOKIE arrays.

2 1955 posted 16 years ago by kirik

SQL SQL Server String Split Function

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

0 1923 posted 17 years ago by rengber

SQL Redux Auth Table SQL

1 1735 posted 17 years ago by pdswan

SQL Search stored procedures for string

0 1555 posted 17 years ago by charmcitycoder

PHP Create SQL OR ID List

0 1669 posted 17 years ago by iloveitaly

PHP sqlDataObj in PHP5

Pretty straight forward implementation of mysql instantiation using php5 oop. Example usage at the bottom. The database in the example is named 'example_database' and has 1 table, 'newstable'. This table has three columns: 'id,heading,message'. By...

0 1406 posted 17 years ago by bakkelun

Rails Count Rows in Sql

count(*args) Count operates using three different approaches. Count all: By not passing any parameters to count, it will return a count of all the rows for the model. Count using column: By passing a column name to count, it will return a count of...

1 1806 posted 17 years ago by deschism