dbtpl is a command-line tool to inspect and generate templated code based on a database schema or a custom database query. In addition to being able to generate standardized "model" code for a ...

description Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.

Msg 10738, Level 15, State 1, Line 1005 The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values. This means that you should break the values ...

Microsoft last week announced the release of SQL Server 2022 Release Candidate (RC) 0. The RC 0 designation is old Microsoft phraseology. It used to mean that the software bits were feature complete ...

I've used DSPPGMREF for decades. There were some 3rd party software offerings along the way that did a better job of providing a complete object cross reference database. DSPPGMREF is what most people ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...