In this post, I will write an article about SQL Server DDL Triggers. DDL triggers are an exceptional sort of trigger that fire in light of Data Definition
In Enterprise applications, we find that there are numerous tables and those may be normalized. So data to be inserted for a “Business Entity” may be split into
In this blog I will explain one of the major application in stored procedure that will execute one procedure from another procedure with parameters in SQL Server Let’s
In this blog, we will look into accessing a newly-added column to a table. We can add a new column to an existing table. [crayon-6515dce53d38e678938498/] Similarly, we can
In this blog, we will see how to get the default path of data and log files using “SERVERPROPERTY”. What is “SERVERPROPERTY”? “SERVERPROPERTY” is a System-defined function used
There are lots of companies that use Microsoft services for creating and editing databases and table records. It is one of the most sought-after technology when it comes
