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 1946 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 2417 posted 15 years ago by theonlyalterego

Other SQL - Find Table by Name

0 2696 posted 15 years ago by silentpro

Other SQL - Find Duplicate Rows

0 1664 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 2503 posted 15 years ago by emregulcan

SQL More Efficient Method for Paging

1 1369 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 1400 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 6884 posted 15 years ago by Mithun

MySQL Updated mysql database from SQL dump

0 1834 posted 15 years ago by greeneggs614

Other Load Postgres database with psql dump

0 1584 posted 15 years ago by greeneggs614

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

0 2233 posted 15 years ago by kashif21

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

drop_tables_like(pattern, db)

0 1578 posted 15 years ago by abstraktor

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

0 2102 posted 15 years ago by kashif21

PHP Simple Database Insert

Just a simple php insert script.

0 1561 posted 15 years ago by JonnySnip3r

SQL Dynamic sql more than 4000 chars

0 1469 posted 15 years ago by hairajeshk

C# Reading data into a dataset in C#

Snip it if you keep forgetting how its done.

1 1828 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 1702 posted 15 years ago by fengelz

SQL SQL Value conversion function

0 1459 posted 15 years ago by kashif21

SQL SQl Select cluase value conversion

0 1389 posted 15 years ago by kashif21

JavaScript sql query using javascript

0 2398 posted 15 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1721 posted 15 years ago by samwa

SQL Find duplicate rows in a table

1 1727 posted 15 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1273 posted 15 years ago by marvin9000

SQL sql order by with case

1 1591 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 1825 posted 15 years ago by sp4ke

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1687 posted 15 years ago by dotNetkow

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

(Grabs all info that matches both tables)

0 1235 posted 15 years ago by staley412

SQL Shrink all development databases

0 1438 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1505 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 1344 posted 15 years ago by emregulcan