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 1044 posted 15 years ago by hoffstein

MySQL Select alÃ©atoire avec MySQL 5

0 707 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 896 posted 15 years ago by RICHARDP

PHP Wordpress "prepare" function for inserting into database

0 722 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 971 posted 15 years ago by webonomic

PHP from_unixtime sql

0 721 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 1281 posted 15 years ago by retry

SAS Match Merge using Proc SQL

0 757 posted 16 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 601 posted 16 years ago by mcbutterbuns