Sql

Truncating MySQL tables with foreign key constraints

2016-07-04 ·1 min read

Truncate MySQL tables with foreign key constraints by dropping and recreating constraints or temporarily disabling FOREIGN_KEY_CHECKS.

2012-05-06 ·1 min read

Insert CRLF line breaks into SQL Server strings using CHAR(13) + CHAR(10), with an example UPDATE statement.

2011-09-19 ·1 min read

ODBC connection string examples for SQL Server using either a username and password or Windows authentication with a trusted connection.