Welcome To Snipplr


Everyone's Recent SQL Snippets



1 ... 10 11 12 13 14 ... 18
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 2795 posted 13 years ago by mprabhuram
0 656 posted 13 years ago by metoikos
SQL to alter field contents. linked article is in german.
1 779 posted 13 years ago by iroybot
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 522 posted 13 years ago by mprabhuram
1 465 posted 13 years ago by tvanzele
1 534 posted 13 years ago by tvanzele
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
1 416 posted 13 years ago by tvanzele
by: Narayana Vyas Kondreddi
1 615 posted 13 years ago by keidash
Finds the location of the log and data files for every database in SQL Server
1 602 posted 13 years ago by tcphll
1 346 posted 13 years ago by siliconsys
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 605 posted 13 years ago by jstnno
Change a user password
0 559 posted 13 years ago by manuelstofer
1 554 posted 13 years ago by tvanzele
1 493 posted 13 years ago by PCurd
2 609 posted 13 years ago by tvanzele
0 440 posted 13 years ago by tvanzele
1 423 posted 13 years ago by tvanzele
1 ... 10 11 12 13 14 ... 18