Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 9 10 11 12 13 ... 17
2 592 posted 13 years ago by jx_boi
Use the text files Preview Handler to display SQL files.
2 735 posted 13 years ago by ggponti
1 682 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 777 posted 13 years ago by emregulcan
0 645 posted 13 years ago by Jamie
See the DBLinks that you have created in the past
0 638 posted 13 years ago by mprabhuram
use this to convert the oracle time stamp into a character.
0 720 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 726 posted 13 years ago by emregulcan
5 738 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 690 posted 13 years ago by emregulcan
Use this logic to avoid double counting in ORACLE SQL
1 640 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 2875 posted 13 years ago by mprabhuram
SQL to alter field contents. linked article is in german.
1 820 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 558 posted 13 years ago by mprabhuram
1 493 posted 14 years ago by tvanzele
1 567 posted 14 years ago by tvanzele
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
1 437 posted 14 years ago by tvanzele
Finds the location of the log and data files for every database in SQL Server
1 638 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 640 posted 14 years ago by jstnno
1 ... 9 10 11 12 13 ... 17