Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

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

SQL Find & Replace Text With MySQL

0 1182 posted 14 years ago by BFTrick

PL/SQL Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

0 1619 posted 14 years ago by theonlyalterego

Other SQL - Find Table by Name

0 1146 posted 14 years ago by silentpro

Other SQL - Find Duplicate Rows

0 1030 posted 14 years ago by silentpro

C# Check SqlDataReader Column Is Exists (extension method)

This snippet is "extension method" for IDataReader. You can use this snippet below ; I assume you have datareader like that SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.IsColumnExists("columnName")) { //do something...

0 1678 posted 14 years ago by emregulcan

SQL More Efficient Method for Paging

1 863 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 919 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 5717 posted 14 years ago by Mithun

MySQL Updated mysql database from SQL dump

0 1105 posted 14 years ago by greeneggs614

Other Load Postgres database with psql dump

0 1028 posted 14 years ago by greeneggs614

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

0 1424 posted 14 years ago by kashif21

MySQL alle Tabellen eines bestimmten Musters aus einer Datenbank lÃ¶schen

drop_tables_like(pattern, db)

0 943 posted 14 years ago by abstraktor

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

0 1333 posted 14 years ago by kashif21

PHP Simple Database Insert

Just a simple php insert script.

0 961 posted 14 years ago by JonnySnip3r

SQL Dynamic sql more than 4000 chars

0 887 posted 14 years ago by hairajeshk

C# Reading data into a dataset in C#

Snip it if you keep forgetting how its done.

1 1107 posted 14 years ago by fengelz

C# Inserting Data With C# and parameterized values

Not that theres anything new to this. In fact its very old fashioned, but If you like me forget how its done; snip it.

0 1048 posted 14 years ago by fengelz

SQL SQL Value conversion function

0 907 posted 14 years ago by kashif21

SQL SQl Select cluase value conversion

0 879 posted 14 years ago by kashif21

JavaScript sql query using javascript

0 1650 posted 14 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1041 posted 14 years ago by samwa

SQL Find duplicate rows in a table

1 1050 posted 14 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 783 posted 14 years ago by marvin9000

SQL sql order by with case

1 1042 posted 14 years ago by samwa

Bash Light sql like database written in Bash

This was a school project, so it is not well commented but feel free to ask details.

0 1217 posted 14 years ago by sp4ke

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1070 posted 14 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 782 posted 14 years ago by staley412

SQL Shrink all development databases

0 861 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 913 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 904 posted 14 years ago by emregulcan