Login / Register

Share Snipplr

Follow @Snipplr

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

SQL SQL Server 2008 Truncate Transaction Log

server
sql

0 559 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 451 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 1293 posted 13 years ago by emregulcan

SQL cronjob to optimize MySQL database

Cronjob and PHP examples below

mysql

0 521 posted 13 years ago by sdxxx

SQL SQL Template - Drop Column

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

0 475 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 550 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 456 posted 13 years ago by JustMadMike

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

Oracle

0 805 posted 13 years ago by xavsio4

SQL Compare dates in Business Objects Data Integrator with Oracle

Oracle

0 604 posted 13 years ago by xavsio4

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

Oracle

0 590 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 525 posted 13 years ago by ezerick

SQL replace characters with regexp

replace

0 484 posted 13 years ago by ashsa

SQL Display the size of tables

1 565 posted 13 years ago by samwa

SQL Get the MySQL databases size from

mysql

0 527 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 833 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 429 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.