SqlServer

Detecting and acting on the database name to change query behaviour for example for different company workflows within the same […]

table variables live in tempdb but are created at the declaration and dropped at the end of the batch. This

When publishing a web application which includes an integrated SQL database you receive the following error: Failed to generate a

When writing long query’s or stored procedures using temporary tables, you may run into an error like: Cannot resolve the

Recently i came accross a database that stored customer numbers in a NVARCHAR field and wanted to sort on this