SqlServer: Detecting and acting based on the active database
Detecting and acting on the database name to change query behaviour for example for different company workflows within the same […]
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