MSSQL Query Blog
Where is Trigger Used Most in SQL Server?
Hello everyone, In this article, I will try to give information about where Triggers are used most in SQL Server. Triggers are used in SQL Server to automatically execute a set of SQL statements or stored procedures when specific database events occur, such as INSERT, UPDATE, or DELETE operations on...
What Are Commonly Used System Procedures in SQL Server?
Hello everyone, In this article, I will try to give information about System Procedures, which are widely used in SQL Server. There are many system procedures available in SQL Server, but some of the commonly used ones are: sp_help: This system procedure provides information about a database object, such as...
Function to Make Email Address Compatible in SQL Server
Hello everyone, In this article, I will try to give information about the function that makes the e-mail address compatible in SQL Server. In SQL Server, in some cases, Turkish characters may be entered in the e-mail addresses or it may be necessary to correct the e-mail addresses before entering...