MSSQL Query Blog
-
-
Function that Performs Credit Card Verification in SQL Server
Hello everyone, In this article, I will try to give information about the function that performs credit card verification in SQL Server. In some cases, you may want to perform credit card authentication in SQL Server. You can easily do this using the function below. CREATE FUNCTION dbo.KrediKartiDogrulamasiYapanFonksiyon(@inputString VARCHAR(20)) RETURNS...
-
-
-
-
-
-
-
Differences Between Truncate and Delete in SQL Server
Hello everyone, In this article, I will give information about the differences between Truncate and Delete in SQL Server. We’ve all wondered about the differences between Truncate and Delete, which we all use in SQL Server. Both commands delete the data inside the table, not the structural content of the...
-
What are the Advantages of Using Procedures in SQL Server?
Hello everyone, In this article, I will try to give information about the advantages of using Procedures in SQL Server. Procedures are pre-written code blocks that can be stored and executed in a SQL Server database. Here are some advantages of using procedures in SQL Server: Reusability: Procedures can be...
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...