Views and changes

T-SQL Integer Data-Type Conversions

This article will show some common integer data-type conversions using T-SQL.

Temp Tables

Restricting updates?

Delete old backup

Delete old backup files on a prespecified folder.

10 tips on converting MS SQL queries to MySQL

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.

Logical Operators

Select Statement

The T-SQL of CSV: Comma-Delimited of Errors

Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.

SELECT * usage