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 880 posted 15 years ago by tobewan

SQL Grab Plesk FTP account passwords

server
sql

0 850 posted 15 years ago by tobewan

SQL Delete All Foreign Keys

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

2 894 posted 15 years ago by marcocs

SQL SQL UPDATE SELECT

update

1 1004 posted 15 years ago by thomasvdb

SQL Create New User and Grant

sql
user

1 941 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 1237 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 1144 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 1096 posted 15 years ago by rengber

SQL Redux Auth Table SQL

1 1030 posted 15 years ago by pdswan

SQL CodeIgniter Session Table SQL

4 1122 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 1067 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 1078 posted 15 years ago by marcocs

SQL Search stored procedures for string

0 930 posted 15 years ago by charmcitycoder

SQL Foreign Keys & DB Design

More for me than anything else

2 862 posted 15 years ago by iloveitaly

SQL Change owner on sql server db.

0 1003 posted 15 years ago by d020

SQL Postgres replace

replace

0 902 posted 16 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 1104 posted 16 years ago by blackf0rk

SQL Search Function-Responsibility relation

function

0 659 posted 16 years ago by datelt

SQL BIRT repts - vortex monthly uniques

0 806 posted 16 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 1027 posted 16 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 1140 posted 16 years ago by theonlyalterego

SQL Adding GIS Support to Postgresql

* be postgres user

0 771 posted 16 years ago by kungfoo

SQL Extract logins default db

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

0 769 posted 16 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 911 posted 16 years ago by blackf0rk

SQL sql: Create minimum table

sql
table

0 972 posted 16 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 1239 posted 16 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 1095 posted 16 years ago by rengber

SQL Remove time from datetime

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

0 1036 posted 16 years ago by flurk118

SQL TSQL to Start a Job Programatically

database

0 1013 posted 16 years ago by rengber

SQL Basic TSQL Cursor Syntax

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

database

0 1163 posted 16 years ago by rengber