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

Welcome To Snipplr

Everyone's Recent SQL Snippets

« Prev 1 ... 12 13 14 15 16 17 18 Next »

SQL Get Plesk FTP account passwords w/o logging into MySQL

server
sql

0 708 posted 15 years ago by tobewan

SQL Grab Plesk FTP account passwords

server
sql

0 671 posted 15 years ago by tobewan

SQL Delete All Foreign Keys

Delete All Foreign Keys in a database; (make sure you USE keyword)

2 756 posted 15 years ago by marcocs

SQL SQL UPDATE SELECT

update

1 841 posted 15 years ago by thomasvdb

SQL Create New User and Grant

sql
user

1 802 posted 15 years ago by wearetherock

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

1 1036 posted 15 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 940 posted 15 years ago by rengber

SQL SQL Server String Split Function

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

0 915 posted 15 years ago by rengber

SQL Redux Auth Table SQL

1 875 posted 15 years ago by pdswan

SQL CodeIgniter Session Table SQL

4 952 posted 15 years ago by pdswan

SQL Full Backup Script With Device

Crear un backup de una base de datos en SQL Server 2005/08 desde cÃ³digo en la posiciÃ³n definida por Device. Cuidado con los permisos: http://support.microsoft.com/kb/207187/es

backup

1 888 posted 15 years ago by marcocs

SQL Full Backup Script

Crear un backup de una base de datos en SQL Server 2005/08 desde cÃ³digo en la posiciÃ³n predefinida del disco. Para agregar un dispositivo y hacer el backup en posiciÃ³n no predefinida: http://msdn.microsoft.com/es-es/library/ms188409(SQL.90).as...

backup

1 903 posted 15 years ago by marcocs

SQL Search stored procedures for string

0 788 posted 15 years ago by charmcitycoder

SQL Foreign Keys & DB Design

More for me than anything else

2 711 posted 15 years ago by iloveitaly

SQL Change owner on sql server db.

0 827 posted 15 years ago by d020

SQL Postgres replace

replace

0 735 posted 15 years ago by jturmel

SQL Return a table list with row count

This will return a list of all the tables in a certain database along with their row count.

list
table

1 948 posted 15 years ago by blackf0rk

SQL Search Function-Responsibility relation

function

0 535 posted 15 years ago by datelt

SQL BIRT repts - vortex monthly uniques

0 667 posted 15 years ago by rowntreerob

SQL Last Backup Date for All databases

In a migration scenario, you may need to take a backup and a differential later to split the transfer over time. But to make it work, there shouldn't be any other full backup in between. This will help you check the last full backup date. Of course,...

backup

0 827 posted 15 years ago by pollusb

SQL Oracle SQL - Select OAF File version history

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....

0 916 posted 15 years ago by theonlyalterego

SQL Adding GIS Support to Postgresql

* be postgres user

0 642 posted 15 years ago by kungfoo

SQL Extract logins default db

Extract logins default db settings from one server to export to another

0 648 posted 15 years ago by pollusb

SQL Randomize Query in SQL

Sometimes you want to return a bunch of data from a table, but you want it coming back in a random order. Maybe it's for keeping some content on a home page fresh. Here's how:

0 787 posted 15 years ago by blackf0rk

SQL sql: Create minimum table

sql
table

0 817 posted 15 years ago by smoover

SQL Connect SQL Server to a Windows Shared Folder

This is how you can connect SQL Server to a Share folder for your backups. After running this, you will see the letter T: in the GUI. Each line must be run seperatly.

backup

0 1047 posted 15 years ago by pollusb

SQL TSQL Try Catch Error Handling

This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.

database

0 912 posted 15 years ago by rengber

SQL Remove time from datetime

select cast(floor(cast(getdate() as float)) as datetime)

0 870 posted 15 years ago by flurk118

SQL TSQL to Start a Job Programatically

database

0 834 posted 15 years ago by rengber

SQL Basic TSQL Cursor Syntax

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

database

0 985 posted 15 years ago by rengber