Here, I am going to cover the basics of Try-Catch error handling mechanism in T-SQL which is introduced in SQL Server 2005. It includes the usage of error functions to return information about the error using the Try-Catch block in the queries. There are ...
What Dependency Injection Is Actually Meant For?
Dependency Injection ensures that high level object is independent of low level object. In conventional programming modules dependency relationships are imagined as high level objects directly related to low level objects. But the dependency injection pa ...
Fixing Update Statement Errors Caused by Foreign Key Constraints in SQL
When the primary key table is updated, an error may occur if it is referenced by a dependent table. This error indicates that the update statement conflicted with the dependency between the two tables. To overcome this error, you can either update the de ...