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 ... 12 13 14 15 16 17 Next »

SQL Foreign Keys & DB Design

More for me than anything else

2 1515 posted 17 years ago by iloveitaly

SQL Change owner on sql server db.

0 1815 posted 17 years ago by d020

C# ASP.net: Update SQL from a DropDownList dynamically created in a GridView.

Bind the DropDownList like normal (set DataSourceID, DataTextField, DataValueField), and <%BIND%> the SelectedValue field. AutoPostBack should be enabled. In the OnSelectedIndexChanged:

0 2267 posted 17 years ago by jink

ASP ASP.net: Retrieve connection string from web.config

Replace *SERVERNAME* with the name of the server name in the web.config

2 2129 posted 17 years ago by jink

C# Simple SubSonic Collection Query

This is an example piece of code that will load a SubSonic collection into the "col1" object. The collection class is told to look for the column "VendorId" in the products table and pull it based based on the matching supplied vendorId.

0 1705 posted 17 years ago by mordecaix7

SQL BIRT repts - vortex monthly uniques

0 1481 posted 17 years ago by rowntreerob

SQL Oracle SQL - Select OAF File version history

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....

0 1969 posted 17 years ago by theonlyalterego

Java Replace the wildcard-character with defined charater for SQL queries

0 1889 posted 17 years ago by walokra

SQL Adding GIS Support to Postgresql

* be postgres user

0 1530 posted 17 years ago by kungfoo

SQL Randomize Query in SQL

Sometimes you want to return a bunch of data from a table, but you want it coming back in a random order. Maybe it's for keeping some content on a home page fresh. Here's how:

0 1685 posted 17 years ago by blackf0rk

SQL sql: Create minimum table

0 1779 posted 17 years ago by smoover

MySQL MySQL table size, number of rows, and size of indexes

Show table size, number of rows, and size of indexes in MySQL.

1 2477 posted 17 years ago by zingo

PHP MySQL JSON Schema Tree

0 1879 posted 17 years ago by jonniespratley

PHP JSON To SQL Generator (JQUERY)

2 2195 posted 17 years ago by jonniespratley

PHP Full REST JSON MySQL Management Class

I am currently still working on this, and will make changes.

1 2042 posted 17 years ago by jonniespratley

SQL Remove time from datetime

select cast(floor(cast(getdate() as float)) as datetime)

0 1890 posted 17 years ago by flurk118

PHP Add custom column in Propel

0 1895 posted 17 years ago by eden159

ASP Execute SQL Scalar Select with ASP.NET 3.5

0 1890 posted 17 years ago by wrburgess

PHP SQL query per caricare nodi specifici in Drupal 2

0 2104 posted 17 years ago by albertomori

SQL Select random row from a SQL database.

This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.

1 1958 posted 17 years ago by xtheonex

MySQL MySQL Capitalize

1 1625 posted 17 years ago by ping_ch

SQL Getting Count's with a UNION of two tables

I was having the hardest time getting this to work. It's a collection of various items. For whatever reason, I needed to include the CASE statement due to NULL's coming back. If this helps you out... go for it.

0 1770 posted 17 years ago by gembry

SQL Selecting a Random Row In Microsoft SQL Server

0 1986 posted 17 years ago by jordantbro

Other Database Connection Class

0 1880 posted 17 years ago by jonniespratley

SQL Creating a random password using dictionary table

Create a random password using a Dictionary database table. Selects a random word, and then appends two random numbers to the end, creating passwords in the form of: foozling98 or laicism11

1 1829 posted 17 years ago by mynameisharry

SQL user innodb in mysql

0 1321 posted 17 years ago by manec

SQL rename a column is MS SQL

Just replace TABLENAME.OLD_COLUMNNAME and NEW_COLUMNNAME with your new values.

0 1730 posted 17 years ago by naspinski

PHP CI CRUD Model - JOIN Example

2 1953 posted 17 years ago by jtkendall

SQL Duplicate or clone one or more rows in MySQL

1 4573 posted 17 years ago by gfazioli

SQL mysql update replace

0 1620 posted 17 years ago by ginoplusio