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

SQL Adding GIS Support to Postgresql

* be postgres user

0 443 posted 15 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 565 posted 15 years ago by blackf0rk

SQL sql: Create minimum table

0 592 posted 15 years ago by smoover

SQL Remove time from datetime

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

0 627 posted 15 years ago by flurk118

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 622 posted 15 years ago by xtheonex

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 557 posted 15 years ago by gembry

SQL Selecting a Random Row In Microsoft SQL Server

0 659 posted 15 years ago by jordantbro

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 600 posted 15 years ago by mynameisharry

SQL user innodb in mysql

0 382 posted 15 years ago by manec

SQL rename a column is MS SQL

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

0 615 posted 15 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

1 2385 posted 15 years ago by gfazioli

SQL mysql update replace

0 523 posted 15 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 761 posted 15 years ago by janetmck

SQL MYSQL add counter in query

1 636 posted 15 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

1 629 posted 15 years ago by pointer

SQL SQL case sensitive match for user and password

When you make a login remember to use CASE SENSITIVE on password and case insensitive on username

0 726 posted 15 years ago by ginoplusio

SQL Import data from tab - delimited datafile to SQL table.

Fields are tab delimited and need to match table schema. I've found the tab separator ASCII(009) preferable over using a comma. The second version can help remove double quotation marks around character fields. Don't forget the keyword LOC...

0 845 posted 15 years ago by RICHARDP

SQL Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.

0 1240 posted 15 years ago by retry

SQL Comma-Delimited List using Coalesce

If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

0 575 posted 15 years ago by mcbutterbuns

SQL Grant MySQL Privileges

To grant all privileges to a user from any location login to the mysql shell and run the following queries.

3 653 posted 16 years ago by cbrant

SQL Set MySQL root password

To reset the MySQL root password, login to the mysql shell and run the following commands.