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

SQL Grab Plesk FTP account passwords

server
sql

0 1489 posted 16 years ago by tobewan

SQL Delete All Foreign Keys

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

2 1502 posted 16 years ago by marcocs

SQL SQL UPDATE SELECT

update

1 1816 posted 16 years ago by thomasvdb

SQL Create New User and Grant

sql
user

1 1568 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 2278 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 1974 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 1855 posted 16 years ago by rengber

SQL Redux Auth Table SQL

1 1664 posted 16 years ago by pdswan

SQL CodeIgniter Session Table SQL

4 2078 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 2049 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 1905 posted 16 years ago by marcocs

SQL Search stored procedures for string

0 1514 posted 16 years ago by charmcitycoder

SQL Foreign Keys & DB Design

More for me than anything else

2 1414 posted 17 years ago by iloveitaly

SQL Change owner on sql server db.

0 1687 posted 17 years ago by d020

SQL Postgres replace

replace

0 1577 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 1861 posted 17 years ago by blackf0rk

SQL Search Function-Responsibility relation

function

0 1054 posted 17 years ago by datelt

SQL BIRT repts - vortex monthly uniques

0 1378 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 1735 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 1854 posted 17 years ago by theonlyalterego

SQL Adding GIS Support to Postgresql

* be postgres user

0 1422 posted 17 years ago by kungfoo

SQL Extract logins default db

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

0 1264 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 1568 posted 17 years ago by blackf0rk

SQL sql: Create minimum table

sql
table

0 1653 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 2063 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 1804 posted 17 years ago by rengber

SQL Remove time from datetime

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

0 1776 posted 17 years ago by flurk118

SQL TSQL to Start a Job Programatically

database

0 1739 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 1861 posted 17 years ago by rengber