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 database

« Prev 1 2 Next »

SQL Search column names in databasee

search database for column names http://vyaskn.tripod.com/sql_server_search_and_replace.htm EXEC SearchAllTables 'Computer' GO

database

0 1047 posted 10 years ago by kat

SQL Search column names in databasee

search database for column names

database

0 1065 posted 10 years ago by kat

SQL Schema for the database DVD

database

0 957 posted 13 years ago by georgemathewkunnathoor

SQL Replace local db with new URL

run these in the SQL tab

database

0 974 posted 13 years ago by xcsteve99

SQL Get ID of last inserted record in Access

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

database

0 1130 posted 14 years ago by wizard04

SQL Search for a text in all databases - SQLServerCentral

database

0 1188 posted 14 years ago by ezerick

SQL Find Duplicate Rows in Table

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

database

1 899 posted 14 years ago by ezerick

SQL Solucion al error cuando creamos diagramas de base de datos despues de mudar una BD

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

database

2 1232 posted 14 years ago by derebus

SQL Find and Replace in SQLite

database

1 1164 posted 14 years ago by traeregan

SQL Select Records Beginning With Certain Letter

database

1 903 posted 14 years ago by traeregan

SQL Find Column Name in all tables in a Database

Find column name in all tables of a database

database

2 1319 posted 14 years ago by hairajeshk

SQL Clean Injection from Database Tables

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

database

2 1048 posted 15 years ago by emregulcan

SQL Create UTF8 Database

Create a new utf8 database in MySQL

database

1 965 posted 15 years ago by manuelstofer

SQL move Drupal tags from one vocabulary into another

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

database

2 1031 posted 15 years ago by berkes

SQL Importing a MySQL database in Windows

database

1 1137 posted 15 years ago by Mithun

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:

database

1 1086 posted 15 years ago by tobewan

SQL TSQL Convert DateTime

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

database

1 1236 posted 15 years ago by rengber

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

Dead simple, but often forgotten.

database

1 1143 posted 15 years ago by rengber

SQL SQL Server String Split Function

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.

database

0 1096 posted 15 years ago by rengber

SQL Oracle SQL - Select OAF File version history

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....

database

0 1139 posted 16 years ago by theonlyalterego

SQL TSQL Try Catch Error Handling

This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.

database

0 1095 posted 16 years ago by rengber

SQL TSQL to Start a Job Programatically

database

0 1013 posted 16 years ago by rengber

SQL Basic TSQL Cursor Syntax

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

database

0 1161 posted 16 years ago by rengber

SQL SQL Shrink Transaction Log

database

0 985 posted 16 years ago by DaveChild

SQL SQL Rebuild Dev Database

This script should be run from the "master" database. It will destroy the dev copy of a database and restore from the live copy. Code slightly modified from original (linked).

database

0 940 posted 16 years ago by DaveChild

SQL Storing an IP address in a database table

You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP s...