Advanced Search

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 712 posted 11 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 792 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 812 posted 11 years ago by edwinet
0 712 posted 12 years ago by cesarkohl
How to Export Data From SQL Server to Microsoft Excel Datasheet
0 806 posted 13 years ago by derebus
1 504 posted 14 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 704 posted 14 years ago by tobewan
Dead simple, but often forgotten.
1 724 posted 14 years ago by rengber
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 726 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 602 posted 15 years ago by stavelin
« Prev 1 Next »