Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 766 posted 14 years ago by CDIDevs
Re-seed identity table if rows were deleted/there are gaps in numerical order
2 491 posted 14 years ago by CDIDevs
1 634 posted 14 years ago by CDIDevs
2 675 posted 14 years ago by CDIDevs
1 656 posted 14 years ago by CDIDevs
1 493 posted 14 years ago by magicrebirth
Call it in the button click event after in(de)crementing CurrentPage value
0 490 posted 14 years ago by tomaszsimon
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 1017 posted 14 years ago by zingo
Reset joomla super admin password to ”admin“
1 535 posted 14 years ago by elisium
0 715 posted 14 years ago by kingkool68
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 965 posted 14 years ago by highlyevolved
These statements convert a date/time field into just a date or a time field
2 788 posted 14 years ago by highlyevolved
0 495 posted 14 years ago by tobewan
0 486 posted 14 years ago by tobewan
Delete All Foreign Keys in a database; (make sure you USE keyword)
2 583 posted 14 years ago by marcocs
0 663 posted 14 years ago by almazom
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 756 posted 14 years ago by dreadwarrior
1 609 posted 14 years ago by wearetherock
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 813 posted 14 years ago by rengber
Dead simple, but often forgotten.
1 748 posted 14 years ago by rengber
Function for sanitize input POST, GET, COOKIE arrays.
2 679 posted 14 years ago by kirik
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 734 posted 14 years ago by rengber
1 667 posted 14 years ago by pdswan
0 585 posted 14 years ago by iloveitaly
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 540 posted 14 years ago by bakkelun