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

SQL Find & Replace Text With MySQL

0 1519 posted 14 years ago by BFTrick

SQL More Efficient Method for Paging

1 1014 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 1061 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 6130 posted 14 years ago by Mithun

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

0 1753 posted 14 years ago by kashif21

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

0 1625 posted 14 years ago by kashif21

SQL Dynamic sql more than 4000 chars

0 1080 posted 14 years ago by hairajeshk

SQL SQL Value conversion function

0 1084 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

0 1039 posted 14 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1306 posted 14 years ago by samwa

SQL Find duplicate rows in a table

1 1319 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 918 posted 14 years ago by marvin9000

SQL sql order by with case

1 1210 posted 14 years ago by samwa

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1293 posted 14 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 895 posted 14 years ago by staley412

SQL Shrink all development databases

0 1032 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1124 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 1028 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 2057 posted 14 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 1005 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 1121 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 1113 posted 14 years ago by ezerick

SQL Display the size of tables

1 1064 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 1490 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 946 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 2473 posted 14 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 1095 posted 14 years ago by djmornyc

SQL Get last date of a month

1 1188 posted 14 years ago by samwa

SQL get the first date of a month

1 1431 posted 14 years ago by samwa