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 643 posted 13 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

server
sql

0 727 posted 13 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 652 posted 13 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 1573 posted 13 years ago by emregulcan

SQL cronjob to optimize MySQL database

Cronjob and PHP examples below

mysql

0 692 posted 13 years ago by sdxxx

SQL SQL Template - Drop Column

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

0 648 posted 13 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 719 posted 13 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 609 posted 13 years ago by JustMadMike

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

Oracle

0 1048 posted 13 years ago by xavsio4

SQL Compare dates in Business Objects Data Integrator with Oracle

Oracle

0 789 posted 13 years ago by xavsio4

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

Oracle

0 754 posted 13 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 697 posted 13 years ago by ezerick

SQL replace characters with regexp

replace

0 667 posted 13 years ago by ashsa

SQL Display the size of tables

1 716 posted 13 years ago by samwa

SQL Get the MySQL databases size from

mysql

0 705 posted 13 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 1044 posted 13 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 601 posted 13 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 1041 posted 13 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

sql
table

0 693 posted 13 years ago by djmornyc

SQL Get last date of a month

1 786 posted 13 years ago by samwa

SQL get the first date of a month

1 865 posted 13 years ago by samwa

SQL SQL Server - Find text in stored proc

0 860 posted 13 years ago by SkyeBianca

SQL Set Drupal site online

1 671 posted 13 years ago by titosemi

SQL Set Drupal site offline

drupal
sql

1 624 posted 13 years ago by titosemi

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

error
sql

0 878 posted 13 years ago by staley412

SQL Mysql Random Number Generate

mysql
number

0 708 posted 13 years ago by metoikos

SQL Import data into MySQL from a bcp output file

mysql
sql

0 1390 posted 13 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 1036 posted 13 years ago by derebus

SQL Truncate DateTime

Truncates a DateTime value.

0 525 posted 13 years ago by cdicarlo

SQL Padding character field with leading zeros

0 608 posted 13 years ago by cdicarlo