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