SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure ...

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

Changed approach. Where last week I wrote the script as a stored procedure, I’ve now implemented both the encryption and ...

Type casting SQL Stored Procedure tables . First I’m going to have a look at the slow approach. The first part of the code that we need is call the stored procedure and with the Table function ...

Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function to check the database status. The following example will show the database name ...