Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged sql



1 ... 8 9 10 11 12
1 766 posted 15 years ago by tvanzele
0 814 posted 15 years ago by tvanzele
0 957 posted 15 years ago by tvanzele
1 816 posted 15 years ago by tvanzele
1 789 posted 15 years ago by tvanzele
1 773 posted 15 years ago by tvanzele
0 719 posted 15 years ago by tvanzele
I found this and simply want to store it. It was done by Valentino Vranken
2 3032 posted 15 years ago by ezerick
creates a user that has only access to one database, from any host
1 1247 posted 15 years ago by manuelstofer
Create a new utf8 database in MySQL
1 965 posted 15 years ago by manuelstofer
Here's a handy query for finding duplicates in a table.
3 1047 posted 15 years ago by jmiller
1 921 posted 15 years ago by CDIDevs
1 1112 posted 15 years ago by CDIDevs
Re-seed identity table if rows were deleted/there are gaps in numerical order
2 788 posted 15 years ago by CDIDevs
1 978 posted 15 years ago by CDIDevs
2 1023 posted 15 years ago by CDIDevs
1 991 posted 15 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 1501 posted 15 years ago by zingo
Reset joomla super admin password to ”admin“
1 862 posted 15 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 1349 posted 15 years ago by highlyevolved
These statements convert a date/time field into just a date or a time field
2 1144 posted 15 years ago by highlyevolved
0 850 posted 15 years ago by tobewan
Delete All Foreign Keys in a database; (make sure you USE keyword)
2 894 posted 15 years ago by marcocs
1 941 posted 15 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 1236 posted 15 years ago by rengber
Dead simple, but often forgotten.
1 1143 posted 15 years ago by rengber
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 1096 posted 15 years ago by rengber
1 1030 posted 15 years ago by pdswan
1 ... 8 9 10 11 12