Welcome To Snipplr

Everyone's Recent SQL Snippets

« Prev 1 ... 10 11 12 13 14 ... 18 Next »

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"

Oracle
sql

0 2567 posted 13 years ago by mprabhuram

SQL Postgresql find duplicate columns

find

0 601 posted 13 years ago by metoikos

SQL Search & Replace in MySQL DB

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

1 685 posted 13 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 >

Oracle
sql

0 475 posted 13 years ago by mprabhuram

SQL List of current sessions causing blocking

1 480 posted 13 years ago by tvanzele

SQL list of current locks

1 409 posted 13 years ago by tvanzele

SQL Get current users and connection type

1 456 posted 13 years ago by tvanzele

SQL Copy database diagrams in SQL Server 2005

1 639 posted 13 years ago by BoNzO

SQL Collection of I/O specific DMV's

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

1 363 posted 13 years ago by tvanzele

SQL Global search on DataBase

by: Narayana Vyas Kondreddi

1 556 posted 13 years ago by keidash

SQL Find Physical Files in SQL Server

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

1 522 posted 13 years ago by tcphll

SQL Bulk Delete Comments

wordpress

1 316 posted 13 years ago by siliconsys

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