Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 9 10 11 12 13 ... 17
2 587 posted 13 years ago by jx_boi
Use the text files Preview Handler to display SQL files.
2 727 posted 13 years ago by ggponti
1 675 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 770 posted 13 years ago by emregulcan
0 642 posted 13 years ago by Jamie
See the DBLinks that you have created in the past
0 630 posted 13 years ago by mprabhuram
use this to convert the oracle time stamp into a character.
0 711 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 722 posted 13 years ago by emregulcan
5 730 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 683 posted 13 years ago by emregulcan
Use this logic to avoid double counting in ORACLE SQL
1 629 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 2853 posted 13 years ago by mprabhuram
SQL to alter field contents. linked article is in german.
1 809 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 550 posted 13 years ago by mprabhuram
1 486 posted 13 years ago by tvanzele
1 560 posted 13 years ago by tvanzele
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
1 435 posted 13 years ago by tvanzele
Finds the location of the log and data files for every database in SQL Server
1 633 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 630 posted 14 years ago by jstnno
1 ... 9 10 11 12 13 ... 17