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

« Prev 1 ... 6 7 8 9 10 ... 18 Next »

SQL Insert/Update in one stored procedure

To start my new post area I will share a simple stored procedure that will check if a record exists, if so update it, otherwise create it; Simple hum?! Just Update it to your needs :)

sql
update

0 1135 posted 14 years ago by Whiteagle

SQL SQL Query to create a table in MySQL to store tweets

[Query related to PHP code to save tweets from the twitter search API to a MySQL database](http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ "PHP code to save tweets from the twitter search API to a...

0 2010 posted 14 years ago by eddequincey

SQL sql group by top

sql

0 1073 posted 14 years ago by samwa

SQL Oracle - sql to find what responsibility can run a request / report

Very useful sql to find which responsibility has access to a report or request.

Oracle
sql

0 2903 posted 14 years ago by theonlyalterego

SQL Get ID of last inserted record in Access

Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

database
sql

0 1335 posted 14 years ago by wizard04

SQL How to clear the history list from the \"servername\" field of SSMS Connect-to-server dialog box?

http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx

server
sql

0 2811 posted 14 years ago by derebus

SQL Search and Replace in MySQL Databases

0 1439 posted 14 years ago by iroybot

SQL Find & Replace Text With MySQL

0 1507 posted 14 years ago by BFTrick

SQL More Efficient Method for Paging

sql

1 1002 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...

Oracle
sql

0 1046 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

sql

0 6108 posted 14 years ago by Mithun

SQL magento translate global attributes

magento

0 1140 posted 14 years ago by nico65

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

sql

0 1739 posted 14 years ago by kashif21

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

0 1612 posted 14 years ago by kashif21

SQL Xml Element and data insert ,deletion ,updation

data
xml

0 1017 posted 14 years ago by kashif21

SQL Xml element insertion in XML DATA

data
xml

0 1117 posted 14 years ago by kashif21

SQL Dynamic sql more than 4000 chars

sql

0 1069 posted 14 years ago by hairajeshk

SQL SQL Value conversion function

function
sql

0 1069 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

sql

0 1030 posted 14 years ago by kashif21

SQL Test String is numeric

Oracle

0 978 posted 14 years ago by marvin9000

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

sql

1 1288 posted 14 years ago by samwa

SQL Find duplicate rows in a table

sql

1 1285 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

sql

0 903 posted 14 years ago by marvin9000

SQL sql order by with case

order
sql

1 1194 posted 14 years ago by samwa

SQL Search for a text in all databases - SQLServerCentral

0 1386 posted 14 years ago by ezerick

SQL Delete Magento test orders

magento

2 1110 posted 14 years ago by hotdiggity

SQL Prepare sql in advance

mysql

0 863 posted 14 years ago by markbenfield

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

server
sql

0 1280 posted 14 years ago by dotNetkow

SQL Convert Drupal path_redirect to WordPress Plugin Redirection

This SQL takes the redirects from Drupal 5.5 tables and converts them into a format the WordPress plugin Redirection can understand.

0 1048 posted 14 years ago by ethicka

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

(Grabs all info that matches both tables)

sql

0 885 posted 14 years ago by staley412

« Prev 1 ... 6 7 8 9 10 ... 18 Next »