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...
Formatting Credit Card Number View in SQL Server
Fixing Turkish Characters in a Text in SQL Server
Function to Split Text Containing Comma Separated Words in SQL Server
Differences Between Temporary Table and Table Variable in SQL Server
Listing Login Users in SQL Server
Finding the Physical Size of a Table in SQL Server
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...
What is Union in SQL Server? How is it used?
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...
How to Fix Configuration Manager Not Found in SQL Server
Listing When Full, Differential and Log Backups of All Databases Are Taken in SQL Server
How Much RAM Does Which Database Use in SQL Server?
Fitting Unfit Codes to the Query Screen in SQL Server
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...