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

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

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

server
sql

0 1790 posted 17 years ago by tobewan

SQL Grab Plesk FTP account passwords

server
sql

0 1712 posted 17 years ago by tobewan

SQL Delete All Foreign Keys

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

2 1708 posted 17 years ago by marcocs

SQL SQL UPDATE SELECT

update

1 2064 posted 17 years ago by thomasvdb

SQL Create New User and Grant

sql
user

1 1833 posted 17 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 2523 posted 17 years ago by rengber

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

Dead simple, but often forgotten.

1 2271 posted 17 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 2096 posted 17 years ago by rengber

SQL Redux Auth Table SQL

1 1916 posted 17 years ago by pdswan

SQL CodeIgniter Session Table SQL

4 2394 posted 17 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 2326 posted 17 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 2167 posted 17 years ago by marcocs

SQL Search stored procedures for string

0 1722 posted 17 years ago by charmcitycoder

SQL Foreign Keys & DB Design

More for me than anything else

2 1633 posted 17 years ago by iloveitaly

SQL Change owner on sql server db.

0 1911 posted 17 years ago by d020

SQL Postgres replace

replace

0 1774 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 2097 posted 17 years ago by blackf0rk

SQL Search Function-Responsibility relation

function

0 1219 posted 17 years ago by datelt

SQL BIRT repts - vortex monthly uniques

0 1599 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 1959 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 2112 posted 17 years ago by theonlyalterego

SQL Adding GIS Support to Postgresql

* be postgres user

0 1653 posted 17 years ago by kungfoo

SQL Extract logins default db

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

0 1439 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 1792 posted 17 years ago by blackf0rk

SQL sql: Create minimum table

sql
table

0 1894 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 2352 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 2047 posted 17 years ago by rengber

SQL Remove time from datetime

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

0 2005 posted 17 years ago by flurk118

SQL TSQL to Start a Job Programatically

database

0 1970 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 2091 posted 17 years ago by rengber