Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged query

« Prev 1 Next »

SQL Viewing Trigger Order (First and Last)

This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

query

0 1147 posted 12 years ago by edwinet

SQL PostgreSQL wildcard search for any of a list of words

PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.

query

0 1296 posted 12 years ago by alecolucci

SQL Auditing SQL Server User and Role Permissions for Databases

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 (...

query

0 1275 posted 12 years ago by edwinet

SQL if mysql_query is not empty

query

0 1127 posted 13 years ago by cesarkohl

SQL Export Data From SQL Server to Microsoft Excel Datasheet

How to Export Data From SQL Server to Microsoft Excel Datasheet

query

0 1320 posted 14 years ago by derebus

SQL Select Records Beginning With Certain Letter

query

1 907 posted 14 years ago by traeregan

SQL Return Cached Query Plans

query

1 844 posted 15 years ago by PCurd

SQL Find all databases and login credentials

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:

query

1 1096 posted 15 years ago by tobewan

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

query

1 1152 posted 15 years ago by rengber

SQL SQL case sensitive match for user and password

When you make a login remember to use CASE SENSITIVE on password and case insensitive on username

query

0 1151 posted 16 years ago by ginoplusio

SQL Find all categories NOT used in current item

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...

query

0 1030 posted 16 years ago by stavelin