This function is capable of being used remotely only on servers with SQL Server 2012 servers or later. The example shows the conventional use of SMALLDATETIMEFROMPARTS. Note the resulting value ...

They can be executed against any database, in a stored procedure or other scripts, just like all other T-SQL statements. Here, I'll discuss conversion functions and the first date and time function.