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 2096 posted 15 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 2583 posted 15 years ago by theonlyalterego

Other SQL - Find Table by Name

0 2866 posted 15 years ago by silentpro

Other SQL - Find Duplicate Rows

0 1793 posted 15 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 2656 posted 15 years ago by emregulcan

SQL More Efficient Method for Paging

1 1488 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 1523 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 7055 posted 15 years ago by Mithun

MySQL Updated mysql database from SQL dump

0 1994 posted 15 years ago by greeneggs614

Other Load Postgres database with psql dump

0 1722 posted 15 years ago by greeneggs614

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

0 2392 posted 15 years ago by kashif21

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

drop_tables_like(pattern, db)

0 1709 posted 15 years ago by abstraktor

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

0 2261 posted 15 years ago by kashif21

PHP Simple Database Insert

Just a simple php insert script.

0 1700 posted 15 years ago by JonnySnip3r

SQL Dynamic sql more than 4000 chars

0 1627 posted 15 years ago by hairajeshk

C# Reading data into a dataset in C#

Snip it if you keep forgetting how its done.

1 1992 posted 15 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 1838 posted 15 years ago by fengelz

SQL SQL Value conversion function

0 1573 posted 15 years ago by kashif21

SQL SQl Select cluase value conversion

0 1514 posted 15 years ago by kashif21

JavaScript sql query using javascript

0 2549 posted 15 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1849 posted 15 years ago by samwa

SQL Find duplicate rows in a table

1 1851 posted 15 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1378 posted 15 years ago by marvin9000

SQL sql order by with case

1 1718 posted 15 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 1942 posted 15 years ago by sp4ke

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1840 posted 15 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 1335 posted 15 years ago by staley412

SQL Shrink all development databases

0 1531 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1628 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 1471 posted 15 years ago by emregulcan