Snipplr

(SQL) Oracle Database Version - geekzspot

Tue, 23 Oct 2012 07:14:34 GMT

If you do not have access to the v$ Tables then you can use SQL Developer: SQL Developer > View > Reports > Data Dictionary Reports > About Your Database > Version Banner

(SQL) Schema for the database DVD - georgemathewkunnathoor

Fri, 19 Aug 2011 16:06:56 GMT

(SQL) Replace local db with new URL - xcsteve99

Fri, 29 Jul 2011 08:10:23 GMT

run these in the SQL tab

(SQL) Get ID of last inserted record in Access - wizard04

Wed, 08 Jun 2011 06:46:45 GMT

Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

(SQL) Search for a text in all databases - SQLServerCentral - ezerick

Thu, 03 Mar 2011 08:07:05 GMT

(SQL) Find Duplicate Rows in Table - ezerick

Sat, 22 Jan 2011 04:47:21 GMT

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

(SQL) boolean column for oracle database tables - geekzspot

Tue, 07 Dec 2010 15:53:32 GMT

Boolean values (usually represented as Checkboxes in a User Interface) This is efficient because is does not suffer the clumsy and inefficient case problems of WHERE UPPER(column) = UPPER(variable);

(SQL) Solucion al error cuando creamos diagramas de base de datos despues de mudar una BD - derebus

Wed, 06 Oct 2010 01:36:41 GMT

Solucion a error cuando mudamos una bd de una pc a otra y luego no podemos crear un diagrama de la BD

(SQL) Find and Replace in SQLite - traeregan

Sun, 26 Sep 2010 01:58:24 GMT

(SQL) Select Records Beginning With Certain Letter - traeregan

Sat, 25 Sep 2010 00:13:20 GMT

(SQL) Find Column Name in all tables in a Database - hairajeshk

Wed, 15 Sep 2010 15:42:26 GMT

Find column name in all tables of a database

(SQL) Clean Injection from Database Tables - emregulcan

Tue, 15 Jun 2010 08:21:53 GMT

You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '','')

(SQL) Create UTF8 Database - manuelstofer

Wed, 10 Mar 2010 06:29:55 GMT

Create a new utf8 database in MySQL

(SQL) move Drupal tags from one vocabulary into another - berkes

Fri, 08 Jan 2010 04:41:13 GMT

I had several vocabularies but wanted to merge them into one. A simple query does this for you. The vocabulary_id where I wanted to merge all the tags into is 3 The vocabulary_id where the tags are to be merged from is 7, 8 and 12

(SQL) Select to read content of a CLOB column with Oracle DB - andreiabohner

Sun, 27 Dec 2009 14:11:17 GMT

(SQL) Importing a MySQL database in Windows - Mithun

Fri, 30 Oct 2009 00:57:49 GMT

(SQL) Find all databases and login credentials - tobewan

Thu, 29 Oct 2009 17:45:37 GMT

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:

(SQL) TSQL Convert DateTime - rengber

Thu, 03 Sep 2009 21:48:26 GMT

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

(SQL) TSQL to Get the SQL Autonumber ID of the Row Just Inserted - rengber

Mon, 31 Aug 2009 22:48:15 GMT

Dead simple, but often forgotten.

(SQL) SQL Server String Split Function - rengber

Wed, 29 Jul 2009 23:37:26 GMT

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.