Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax array c forms

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

« Prev 1 ... 7 8 9 10 11 12 Next »

SQL Oracle TimeStamp to Char conversion

use this to convert the oracle time stamp into a character.

0 1792 posted 16 years ago by mprabhuram

SQL Return Multiple Values Stored Procedure

1 1744 posted 16 years ago by vedgiee

SQL Clean SQL Injection from your tables

This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.

2 2152 posted 16 years ago by emregulcan

SQL Find all Foreign Keys in a SQL Server DB

1 2556 posted 16 years ago by ezerick

SQL Clean Injection from Database Tables

You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')

2 2127 posted 16 years ago by emregulcan

SQL How to avoid double counting

Use this logic to avoid double counting in ORACLE SQL

1 1869 posted 16 years ago by mprabhuram

SQL Oracle - Overlaps function

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 4693 posted 16 years ago by mprabhuram

SQL Search & Replace in MySQL DB

SQL to alter field contents. linked article is in german.

1 1907 posted 16 years ago by iroybot

SQL Ranking Function - Range over partition - Oracle Analytical function

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 1576 posted 16 years ago by mprabhuram

SQL List of current sessions causing blocking

1 1578 posted 16 years ago by tvanzele

SQL list of current locks

1 1521 posted 16 years ago by tvanzele

SQL Get current users and connection type

1 1492 posted 16 years ago by tvanzele

SQL Copy database diagrams in SQL Server 2005

1 2059 posted 16 years ago by BoNzO

SQL Collection of I/O specific DMV's

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry

1 1338 posted 16 years ago by tvanzele

SQL Find Physical Files in SQL Server

Finds the location of the log and data files for every database in SQL Server

1 1772 posted 16 years ago by tcphll

SQL Sistema de envÃos Magento para Chile

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 1775 posted 16 years ago by jstnno

SQL Search and Replace String in an SQL Server nText Field

1 2418 posted 16 years ago by Meander365

SQL Index Read/Write/Fill Factor stats (current DB)

1 1601 posted 16 years ago by tvanzele

SQL List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i

1 2529 posted 16 years ago by tvanzele

SQL List of single-use, ad-hoc queries that are bloating the plan cache

1 1657 posted 16 years ago by tvanzele

SQL Display logfile size and usage via dmv

0 1551 posted 16 years ago by tvanzele

SQL Display logfile size and usage via dbcc