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 SQL shows how to select a row from a table using the current financial year as the WHERE...
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 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...