SMALLDATETIMEFROMPARTS() – Date/Time Function

I am steadfast in writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…