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 Tagged sql

« Prev 1 ... 5 6 7 8 9 ... 12 Next »

SQL Search and Replace in MySQL Databases

0 1197 posted 14 years ago by iroybot

SQL Find & Replace Text With MySQL

0 1173 posted 14 years ago by BFTrick

SQL More Efficient Method for Paging

1 848 posted 14 years ago by samwa

SQL Cambiare tipo in colonna ORACLE

Per cambiare il tipo di dato in una colonna devo fare un giretto...

0 909 posted 14 years ago by tuffo19

SQL Count number of tables, views, stored procedures or functions

You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view

0 5692 posted 14 years ago by Mithun

SQL Complete example of Triggers in insert,Update and delete scenario

0 1415 posted 14 years ago by kashif21

SQL SQL SERVER â€“ Useful DateTime Functions to Find Specific Dates

0 1316 posted 14 years ago by kashif21

SQL Dynamic sql more than 4000 chars

0 875 posted 14 years ago by hairajeshk

SQL SQL Value conversion function

0 893 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

0 862 posted 14 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1025 posted 14 years ago by samwa

SQL Find duplicate rows in a table

1 1037 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 767 posted 14 years ago by marvin9000

SQL sql order by with case

1 1029 posted 14 years ago by samwa

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1045 posted 14 years ago by dotNetkow

SQL INNER JOIN (Grabs all info that matches both tables)

(Grabs all info that matches both tables)

0 764 posted 14 years ago by staley412

SQL Shrink all development databases

0 843 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 896 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 881 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 1831 posted 14 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 830 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 926 posted 14 years ago by edwinet

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

1 900 posted 14 years ago by ezerick

SQL Display the size of tables

1 893 posted 14 years ago by samwa

SQL Search SQL Server field names and stored procedure text

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

1 1275 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 778 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 1285 posted 14 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 899 posted 14 years ago by djmornyc

SQL Get last date of a month

1 968 posted 14 years ago by samwa

SQL get the first date of a month

1 1131 posted 14 years ago by samwa