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 1729 posted 14 years ago by iroybot

SQL Find & Replace Text With MySQL

0 1703 posted 14 years ago by BFTrick

SQL More Efficient Method for Paging

1 1182 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 1217 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 6488 posted 14 years ago by Mithun

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

0 1981 posted 14 years ago by kashif21

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

0 1832 posted 14 years ago by kashif21

SQL Dynamic sql more than 4000 chars

0 1254 posted 14 years ago by hairajeshk

SQL SQL Value conversion function

0 1253 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

0 1197 posted 14 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1495 posted 14 years ago by samwa

SQL Find duplicate rows in a table

1 1505 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1103 posted 14 years ago by marvin9000

SQL sql order by with case

1 1397 posted 14 years ago by samwa

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1481 posted 14 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 1046 posted 15 years ago by staley412

SQL Shrink all development databases

0 1208 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1297 posted 15 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 1165 posted 15 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 2239 posted 15 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 1140 posted 15 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 1278 posted 15 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 1286 posted 15 years ago by ezerick

SQL Display the size of tables

1 1228 posted 15 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 1679 posted 15 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 1097 posted 15 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 2673 posted 15 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 1267 posted 15 years ago by djmornyc

SQL Get last date of a month

1 1353 posted 15 years ago by samwa

SQL get the first date of a month

1 1670 posted 15 years ago by samwa