Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 9 10 11 12 13 ... 17
2 603 posted 13 years ago by jx_boi
Use the text files Preview Handler to display SQL files.
2 756 posted 13 years ago by ggponti
1 692 posted 13 years ago by jmcd
You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)
4 790 posted 13 years ago by emregulcan
0 658 posted 13 years ago by Jamie
See the DBLinks that you have created in the past
0 650 posted 13 years ago by mprabhuram
use this to convert the oracle time stamp into a character.
0 734 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 734 posted 13 years ago by emregulcan
5 756 posted 13 years ago by Nettuts
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 699 posted 13 years ago by emregulcan
Use this logic to avoid double counting in ORACLE SQL
1 654 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 2891 posted 13 years ago by mprabhuram
SQL to alter field contents. linked article is in german.
1 829 posted 14 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 575 posted 14 years ago by mprabhuram
1 496 posted 14 years ago by tvanzele
1 576 posted 14 years ago by tvanzele
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
1 449 posted 14 years ago by tvanzele
Finds the location of the log and data files for every database in SQL Server
1 649 posted 14 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 651 posted 14 years ago by jstnno
1 ... 9 10 11 12 13 ... 17