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 array c forms

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

SQL Find & Replace Text With MySQL

0 1912 posted 15 years ago by BFTrick

SQL More Efficient Method for Paging

1 1349 posted 15 years ago by samwa

SQL Cambiare tipo in colonna ORACLE

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

0 1375 posted 15 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 6840 posted 15 years ago by Mithun

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

0 2188 posted 15 years ago by kashif21

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

0 2071 posted 15 years ago by kashif21

SQL Dynamic sql more than 4000 chars

0 1441 posted 15 years ago by hairajeshk

SQL SQL Value conversion function

0 1435 posted 15 years ago by kashif21

SQL SQl Select cluase value conversion

0 1365 posted 15 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1692 posted 15 years ago by samwa

SQL Find duplicate rows in a table

1 1704 posted 15 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1244 posted 15 years ago by marvin9000

SQL sql order by with case

1 1570 posted 15 years ago by samwa

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1651 posted 15 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 1207 posted 15 years ago by staley412

SQL Shrink all development databases

0 1402 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1482 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 1314 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 2424 posted 15 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 1306 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 1443 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 1468 posted 15 years ago by ezerick

SQL Display the size of tables

1 1394 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 1888 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 1248 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 2891 posted 15 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 1450 posted 15 years ago by djmornyc

SQL Get last date of a month

1 1520 posted 15 years ago by samwa

SQL get the first date of a month

1 1862 posted 15 years ago by samwa