This assumes that you have sqlcmd (comes with SQL Server client tools) installed and wish to execute every file ending in .sql within the given directory against the specified server and database using Windows Authentication.

2 1028 posted 15 years ago by hoffstein

MySQL Select alÃ©atoire avec MySQL 5

0 696 posted 15 years ago by sebus

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 874 posted 15 years ago by RICHARDP

PHP Wordpress "prepare" function for inserting into database

0 706 posted 15 years ago by Tate

SAS Use Regular Expressions in Proc SQL

You can use regular expressions within SQL. This can be quite powerful in selecting data that matches certain conditions. The following example shows a simple regular expression which selects only quarterly periods from a table containing years, quar...

0 938 posted 15 years ago by webonomic

PHP from_unixtime sql

0 682 posted 15 years ago by stavelin

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 1254 posted 15 years ago by retry

SAS Match Merge using Proc SQL

0 732 posted 15 years ago by webonomic

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 594 posted 15 years ago by mcbutterbuns