In this video, we will be looking at the first and last days of the current month, and future and past months.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
My Excel for PC courses are:
Beginner to Excel - rebrand.ly/mic...
Intermediate to Expert Advanced - rebrand.ly/mic...
Power Table, Get and Transform and Power Pivot - rebrand.ly/vis...
VBA macros for Excel - rebrand.ly/exc...
----
You can find in the first day in SQL Server by using DATEFROMPARTS - but how can you find the first day of the next or previous month?
It's a lot easier to find the last day in SQL Server by using EOMONTH.
21 авг 2024