Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged sql



1 ... 8 9 10 11 12
0 57 posted 10 years ago by tvanzele
1 83 posted 10 years ago by tvanzele
0 64 posted 10 years ago by tvanzele
1 70 posted 10 years ago by tvanzele
1 74 posted 10 years ago by tvanzele
1 65 posted 10 years ago by tvanzele
0 66 posted 10 years ago by tvanzele
I found this and simply want to store it. It was done by Valentino Vranken
2 370 posted 10 years ago by ezerick
creates a user that has only access to one database, from any host
1 162 posted 10 years ago by manuelstofer
Create a new utf8 database in MySQL
1 87 posted 10 years ago by manuelstofer
Here's a handy query for finding duplicates in a table.
3 123 posted 10 years ago by jmiller
1 111 posted 10 years ago by CDIDevs
1 146 posted 10 years ago by CDIDevs
Re-seed identity table if rows were deleted/there are gaps in numerical order
2 79 posted 10 years ago by CDIDevs
1 103 posted 10 years ago by CDIDevs
2 124 posted 10 years ago by CDIDevs
1 133 posted 10 years ago by CDIDevs
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 165 posted 10 years ago by zingo
Reset joomla super admin password to ”admin“
1 98 posted 10 years ago by elisium
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 164 posted 10 years ago by highlyevolved
These statements convert a date/time field into just a date or a time field
2 136 posted 10 years ago by highlyevolved
0 75 posted 10 years ago by tobewan
Delete All Foreign Keys in a database; (make sure you USE keyword)
2 73 posted 10 years ago by marcocs
1 92 posted 11 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 128 posted 11 years ago by rengber
Dead simple, but often forgotten.
1 133 posted 11 years ago by rengber
1 ... 8 9 10 11 12