T-SQL – How to output day name from date
This T-SQL code demonstrates how to retrieve the day name from a given date using the DATENAME function in SQL Server.
GETDATE
T-SQL – How to output day number from date
Learn how to extract the day number from a date using T-SQL with this simple and effective code snippet. Get the day number for any given date in SQL Server.
T-SQL – How to output name of month
This T-SQL code demonstrates how to display the name of the current month using the DATENAME function in SQL Server.
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
This T-SQL statement demonstrates how to output the day from a date in ordinal numbers using SQL Server. Learn how to replace `Getdate()` with your date field and format the…
SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…
SQL – How to get current financial year using SQL
Learn how to retrieve the current financial year in SQL with this simple and effective solution, assuming the fiscal year starts on July 1st and ends on June 30th. Get…
SQL – How to select current financial year from lookup table
This SQL query demonstrates how to retrieve the current financial year from a lookup table by utilizing the current date, month, year, and cast functions. It returns the selected row…
SQL Server – How to set a datetime field to automatically use current date/time
This article explains how to set a 'datetime' field in an SQL Server database to automatically display the current date and time when the record is created.How to set a…
ConfigMgr Collection Query – Inactive Computers
The article provides a configuration manager collection query that lists inactive computers not seen by active directory for over 90 days using heartbeat discovery method.