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 ... 7 8 9 10 11 ... 18 Next »

SQL Shrink all development databases

server
sql

0 1014 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

server
sql

0 1112 posted 14 years ago by scholli

SQL SQL Inserted Trigger

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier) If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity . So, I write a trigger...

1 1018 posted 14 years ago by emregulcan

SQL sql Raiserror with parameters

You can see details on http://msdn.microsoft.com/en-us/library/ms178592.aspx , but I try to explain how you throw error with "uniqueidentifier" type parameters. I convert uniqueidentifier to string (nvarchar(50)) and set a variable. "%s" is equal...

0 2037 posted 14 years ago by emregulcan

SQL cronjob to optimize MySQL database

Cronjob and PHP examples below

mysql

0 1079 posted 14 years ago by sdxxx

SQL SQL Template - Drop Column

My Drop Column.sql This template drops a columns of the table.

0 989 posted 14 years ago by edwinet

SQL SQL Template - Add Column

My Add Column Varchar.sql This template adds a new varchar column to the table.

0 1098 posted 14 years ago by edwinet

SQL Magento - Update admin IDs after DB Transfer

After transferring a magento databse or restoring one, you'll most likely have to run this code to correct a few IDs that change automaticly.

magento

0 935 posted 14 years ago by JustMadMike

SQL Return a random sample of 5% of records of a table with Oracle

Oracle

0 1609 posted 14 years ago by xavsio4

SQL Compare dates in Business Objects Data Integrator with Oracle

Oracle

0 1209 posted 14 years ago by xavsio4

SQL Get all tables and views having this field in their structure

Oracle

0 1196 posted 14 years ago by xavsio4

SQL Find Duplicate Rows in Table

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

database
sql

1 1093 posted 14 years ago by ezerick

SQL replace characters with regexp

replace

0 1035 posted 14 years ago by ashsa

SQL Display the size of tables

1 1048 posted 14 years ago by samwa

SQL Get the MySQL databases size from

mysql

0 1123 posted 14 years ago by sergeygerasimov

SQL Search SQL Server field names and stored procedure text

Search SQL Server field names and stored procedure text, based on a keyword.

1 1469 posted 14 years ago by axs221

SQL SQL Trim Function

Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction. It's very basic; -First; it's Right Trim (RTrim()) string - And then Left Trim (LTrim())

0 933 posted 14 years ago by emregulcan

SQL Drupal 6 - Fix Menu links you can\'t delete by reseting them to delete via SQL

Used the first sql statement to find your menu item. (Replace menu-% with the name of your menu eg. "primary-links" . Then using the menu item id fix the items you want to regain the good old delete button on the menu item.

0 2460 posted 14 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

sql
table

0 1085 posted 14 years ago by djmornyc

SQL Get last date of a month

1 1178 posted 14 years ago by samwa

SQL get the first date of a month

1 1416 posted 14 years ago by samwa

SQL SQL Server - Find text in stored proc

0 1284 posted 14 years ago by SkyeBianca

SQL Set Drupal site online

1 1098 posted 14 years ago by titosemi

SQL Set Drupal site offline

drupal
sql

1 950 posted 14 years ago by titosemi

SQL Error Script (Find All Errors in a database connection)

error
sql

0 1388 posted 14 years ago by staley412

SQL Mysql Random Number Generate

mysql
number

0 1096 posted 14 years ago by metoikos

SQL Import data into MySQL from a bcp output file

mysql
sql

0 1980 posted 14 years ago by eddequincey

SQL Export Data From SQL Server to Microsoft Excel Datasheet

How to Export Data From SQL Server to Microsoft Excel Datasheet

0 2491 posted 14 years ago by derebus

SQL Truncate DateTime

Truncates a DateTime value.

0 880 posted 14 years ago by cdicarlo

SQL Padding character field with leading zeros

0 963 posted 14 years ago by cdicarlo