Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

See the DBLinks that you have created in the past
0 627 posted 13 years ago by mprabhuram
use this to convert the oracle time stamp into a character.
0 705 posted 13 years ago by mprabhuram
This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.
2 716 posted 13 years ago by emregulcan
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 675 posted 13 years ago by emregulcan
Use this logic to avoid double counting in ORACLE SQL
1 625 posted 13 years ago by mprabhuram
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 2848 posted 13 years ago by mprabhuram
SQL to alter field contents. linked article is in german.
1 804 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 545 posted 13 years ago by mprabhuram
1 484 posted 13 years ago by tvanzele
1 556 posted 13 years ago by tvanzele
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
1 430 posted 13 years ago by tvanzele
Finds the location of the log and data files for every database in SQL Server
1 629 posted 13 years ago by tcphll
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 624 posted 14 years ago by jstnno
Change a user password
0 578 posted 14 years ago by manuelstofer
1 572 posted 14 years ago by tvanzele
2 634 posted 14 years ago by tvanzele