MSSQL Query Blog

31 March 2023

What are the Differences Between COUNT and COUNT_BIG Functions in SQL Server?

Hello everyone, In this article, I will try to give information about the differences between the COUNT and COUNT_BIG functions in SQL Server. COUNT and COUNT_BIG are both aggregate functions in SQL Server that are used to count the number of rows in a table or a result set. The...

Functions / SQL Server

23 March 2023

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. When you create and run...

SQL Server

22 March 2023

Formatting Credit Card Number View in SQL Server

Hello everyone, In this article, I will try to give information about formatting Credit Card number display in SQL Server. In SQL Server, in some cases, you may want to not format the Credit Card number display. You can easily do this using the code below. DECLARE @creditCardNumber VARCHAR(16) =...

SQL Server

19 March 2023

Fixing Turkish Characters in a Text in SQL Server

Hello everyone, In this article, I will try to give information about correcting Turkish characters in a text in SQL Server. In SQL Server, in some cases, you may want to correct Turkish characters in a text. You can easily do this using the code below. DECLARE @Yazi VARCHAR(MAX) =...

Functions / SQL Server

18 March 2023

Function to Split Text Containing Comma Separated Words in SQL Server

Hello everyone, In this article, I will try to give information about the function that splits text containing comma-separated words in SQL Server. In SQL Server you may want to break up comma separated words in some cases. You can easily do this by creating and using the function below....

SQL Server

18 March 2023

Differences Between Temporary Table and Table Variable in SQL Server

Hello everyone, Under this title, we will examine the differences between Temporary Table and Table Variable in SQL Server. In some cases, such questions may come up in job interviews in SQL Server. It will always be useful for you to learn the following items. While Temporary Table is created...

SQL Server

18 March 2023

Listing Login Users in SQL Server

Hello everyone, In this article, I will try to give information about listing Login users in SQL Server. In SQL Server you may want to list Login users in some cases. You can easily do this using the code below. SELECT name AS Login_Name, type_desc AS Account_Type, CASE WHEN is_disabled...

SQL Server / Stored Procedures

18 March 2023

Finding the Physical Size of a Table in SQL Server

Hello everyone, In this article, I will try to give information about learning the physical size of a table in SQL Server. In SQL Server, in some cases you may want to know the physical size of a table. We use the sp_spaceused procedure for this operation. We run our...