Technology Toolbox: SQL Server 2000, ADO, ADO.NET. ... or a user-defined function. SQL Server then stores the script that created the object in the text column of the syscomments system table.

This function is capable of being remoted to SQL Server 2012 servers and later. Unfortunately, it won't be remoted to servers that have a version below SQL Server 2012. SELECT DATETIMEFROMPARTS (2012, ...

Here's a collection of such nuggets for developing SQL Server applications. 1) Replace COUNT(*) With EXISTS When Checking for Existence Developers often use the value from the COUNT(*) function when ...

This restricts which users can view what data in a table, based on a function. SQL Server 2016 introduces this feature, which is very useful in multi-tenant environments where you may want to ...

You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the object in the text column of the ...