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

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 1407 posted 16 years ago by tobewan

SQL Grab Plesk FTP account passwords

server
sql

0 1365 posted 16 years ago by tobewan

SQL Delete All Foreign Keys

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

2 1380 posted 16 years ago by marcocs

SQL SQL UPDATE SELECT

update

1 1675 posted 16 years ago by thomasvdb

SQL Create New User and Grant

sql
user

1 1451 posted 16 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 2148 posted 16 years ago by rengber

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

Dead simple, but often forgotten.

1 1844 posted 16 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 1715 posted 16 years ago by rengber

SQL Redux Auth Table SQL

1 1550 posted 16 years ago by pdswan

SQL CodeIgniter Session Table SQL

4 1966 posted 16 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 1937 posted 16 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 1794 posted 16 years ago by marcocs

SQL Search stored procedures for string

0 1438 posted 16 years ago by charmcitycoder

SQL Foreign Keys & DB Design

More for me than anything else

2 1318 posted 16 years ago by iloveitaly

SQL Change owner on sql server db.

0 1579 posted 16 years ago by d020

SQL Postgres replace

replace

0 1445 posted 17 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 1721 posted 17 years ago by blackf0rk

SQL Search Function-Responsibility relation

function

0 968 posted 17 years ago by datelt

SQL BIRT repts - vortex monthly uniques

0 1253 posted 17 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 1625 posted 17 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 1726 posted 17 years ago by theonlyalterego

SQL Adding GIS Support to Postgresql

* be postgres user

0 1317 posted 17 years ago by kungfoo

SQL Extract logins default db

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

0 1216 posted 17 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 1463 posted 17 years ago by blackf0rk

SQL sql: Create minimum table

sql
table

0 1523 posted 17 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 1948 posted 17 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 1676 posted 17 years ago by rengber

SQL Remove time from datetime

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

0 1658 posted 17 years ago by flurk118

SQL TSQL to Start a Job Programatically

database

0 1604 posted 17 years ago by rengber

SQL Basic TSQL Cursor Syntax

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

database

0 1734 posted 17 years ago by rengber