As a product owner, you always worried about the different security aspect of your application and SQL Server Database is one of the main important parts for which you might worry. And you always think there should be some kind of checklist which you or your team have to check whether your database is secure …
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach of string concatenation. This seems very easy but we need to cast the parameters in VARCHAR and sometimes we stuck in single code. I am sure this happened with all of us. Let’s understand first …