Skip to content
Here’s a little trick you can use to return TRUE/FALSE if a query has returned results. For example if a...
The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for...
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we’ll change...
The following SQL shows how to select a row from a table using the current financial year as the WHERE...
The following SQL shows how to select a row from a table using the current year as the WHERE condition....
The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft...