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 year as the WHERE condition.... The following SQL shows how to select a row from a table using the current financial year as the WHERE... The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft...