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

SQL Find & Replace Text With MySQL

0 1620 posted 14 years ago by BFTrick

SQL More Efficient Method for Paging

1 1099 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 1138 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 6297 posted 14 years ago by Mithun

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

0 1881 posted 14 years ago by kashif21

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

0 1739 posted 14 years ago by kashif21

SQL Dynamic sql more than 4000 chars

0 1171 posted 14 years ago by hairajeshk

SQL SQL Value conversion function

0 1175 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

0 1119 posted 14 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1410 posted 14 years ago by samwa

SQL Find duplicate rows in a table

1 1428 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1026 posted 14 years ago by marvin9000

SQL sql order by with case

1 1322 posted 14 years ago by samwa

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1394 posted 14 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 977 posted 14 years ago by staley412

SQL Shrink all development databases

0 1124 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1215 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 1094 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 2156 posted 14 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 1067 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 1201 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 1216 posted 14 years ago by ezerick

SQL Display the size of tables

1 1158 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 1597 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 1018 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 2581 posted 15 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 1179 posted 15 years ago by djmornyc

SQL Get last date of a month

1 1281 posted 15 years ago by samwa

SQL get the first date of a month

1 1572 posted 15 years ago by samwa