AlfinTech Computer

Simply, sp_executesql is a procedure in SQL Server. It allows to execute the dynamically constructed SQL statements. But, sometimes, executing the constructed SQL statements is a technique used to defeat the problems in SQL programming. By the way, how to execute sp_executesql into a temporary table? Let us discuss it

Continue reading

You may ever find the Entity Framework does not use sp_executesql to execute in .Net 4.0. However, the sp_executesql works to use cached plans to get more performance. Then, what does it happen when Entity Framework does not use sp_executesql and how to fix it? Well, let’s find out about

Continue reading

The sp_executesql is a procedure in SQL Server. It offers to execute of the dynamically constructed SQL statements. Occasionally executing the constructed SQL batches dynamically is a technique used to beat out different problems in SQL programming. For instance, when you want to signify the displayed columns in your reports,

Continue reading

This article describes a new feature for SQL databases in SSMS, static data masking. Previously, the static data masking function was only available in Azure SQL DB. Database administrators are responsible for database security and compliance issues. In a typical workflow, we had multiple environments for applications such as production,

Continue reading

You can use SQL Server’s error handling to control your Transact-SQL code. For example, if something goes wrong, we have the opportunity to do something about it. Troubleshooting SQL Server errors can be as simple as recording an event, or you may want to fix the error. Overview Since we

Continue reading