Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

« Prev 1 ... 9 10 11 12 13 ... 17 Next »

Windows Registry SQL Files Preview Handler

Use the text files Preview Handler to display SQL files.

2 991 posted 14 years ago by ggponti

SQL Get record count for a specific database

1 920 posted 14 years ago by edwinet

C# Simple SQL Server Diff Tool

1 932 posted 14 years ago by jmcd

SQL Find Stored Procedures with specified name or contains specified text

2 1011 posted 14 years ago by lance

SQL Find string anywhere in Sql Database

4 1073 posted 14 years ago by emregulcan

SQL Timezone database

You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)

4 1045 posted 14 years ago by emregulcan

MySQL Move Column in MySQL Table

0 903 posted 14 years ago by Jamie

SQL Create/ View/ Delete DB Links in oracle

See the DBLinks that you have created in the past

0 894 posted 14 years ago by mprabhuram

SQL Oracle TimeStamp to Char conversion

use this to convert the oracle time stamp into a character.

0 954 posted 14 years ago by mprabhuram

SQL Return Multiple Values Stored Procedure

1 882 posted 14 years ago by vedgiee

SQL Clean SQL Injection from your tables

This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.

2 1007 posted 14 years ago by emregulcan

PHP Prepared Statements: Read

5 1010 posted 14 years ago by Nettuts

SQL Find all Foreign Keys in a SQL Server DB

1 1269 posted 14 years ago by ezerick

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>','')

2 947 posted 14 years ago by emregulcan

SQL How to avoid double counting

Use this logic to avoid double counting in ORACLE SQL

1 930 posted 14 years ago by mprabhuram

SQL Oracle - Overlaps function

This function can be used to find out if there exists an overlap between two pairs of dates or time. There is an alternate way to calculate the actual overlapping value - Read the snippet "How to avoid double counts"

0 3376 posted 14 years ago by mprabhuram

SQL Search & Replace in MySQL DB

SQL to alter field contents. linked article is in german.

1 1107 posted 14 years ago by iroybot

SQL Ranking Function - Range over partition - Oracle Analytical function

ROW_NUMBER() - Partition (group by) the expression values and assigns integer values to the rows depending on their order. thx to Shouvik Basu < http://www.orafaq.com/node/55 >

0 818 posted 14 years ago by mprabhuram

SQL List of current sessions causing blocking

1 754 posted 14 years ago by tvanzele

SQL list of current locks

1 727 posted 14 years ago by tvanzele

SQL Get current users and connection type

1 791 posted 14 years ago by tvanzele

SQL Copy database diagrams in SQL Server 2005

1 1013 posted 14 years ago by BoNzO

SQL Collection of I/O specific DMV's

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry

1 644 posted 14 years ago by tvanzele

SQL Find Physical Files in SQL Server

Finds the location of the log and data files for every database in SQL Server

1 887 posted 14 years ago by tcphll

SQL Sistema de envÃos Magento para Chile

Sql para agregar las regiones de Chile en Magento. Utilizado para calcular las tarifas de los envÃos. Probado a travÃ©s del phpmyadmin en una nueva instalaciÃ³n de magento 1.4.x (probablemente funcione con versiones anteriores) Para el tutorial d...

0 892 posted 14 years ago by jstnno

SQL Search and Replace String in an SQL Server nText Field

1 1353 posted 14 years ago by Meander365

SQL Index Read/Write/Fill Factor stats (current DB)

1 795 posted 14 years ago by tvanzele

SQL List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i

1 1195 posted 14 years ago by tvanzele

SQL List of single-use, ad-hoc queries that are bloating the plan cache

1 822 posted 14 years ago by tvanzele

SQL Display logfile size and usage via dmv

0 773 posted 14 years ago by tvanzele