Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged query



« Prev 1 Next »
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
0 690 posted 10 years ago by edwinet
PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.
0 770 posted 11 years ago by alecolucci
The sysprotects system table reports all of the permissions granted or denied in a given database. We'll need to join it with sysusers and sysobjects to get all the information we need. Here's an example query that only pulls information on objects (...
0 794 posted 11 years ago by edwinet
0 690 posted 12 years ago by cesarkohl
How to Export Data From SQL Server to Microsoft Excel Datasheet
0 787 posted 13 years ago by derebus
1 493 posted 13 years ago by PCurd
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:
1 683 posted 14 years ago by tobewan
Dead simple, but often forgotten.
1 708 posted 14 years ago by rengber
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 710 posted 15 years ago by ginoplusio
It's easy to find the categories used on one item, but find all categories NOT used on current item? This snippet stores a "NOT IN" query. This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to w...
0 582 posted 15 years ago by stavelin
« Prev 1 Next »