MSSQL Query Blog

5 April 2022

Finding the Number of Columns in a Table in SQL Server

Hello everyone, In this article, I will try to give information about finding the number of columns in the table in SQL Server. In SQL Server, you may want to know the number of columns in the table in some cases. You can easily do this using the code below....

SQL Server

3 April 2022

Getting List of All Empty Tables in SQL Server

Hello everyone, In this article I will try to give information about getting list of all empty tables in SQL Server. In SQL Server you may want to get a list of all empty tables in some cases. You can easily do this using the code below. s.name schema_name, SUM(p.rows)...

SQL Server

2 April 2022

Getting All the Information of the Server in SQL Server

Hello everyone, In this article, I will try to give information about getting all the information about the server in SQL Server. In SQL Server, in some cases, you may want to see a lot of information about the Server. You can see this information by using the code below....

SQL Server

2 April 2022

Obtaining Various Date Information from Date Information in SQL Server

Hello everyone, In this article, I will try to give information about how to obtain various date information from date information in SQL Server. You may want to see or use different variations of the date information you have in SQL Server. You can use some of this information by...

SQL Server

2 April 2022

Extracting Domain Name from Mail Address in SQL Server

Hello everyone, In this article, I will give information about how to extract the domain name from the mail address in SQL Server. In SQL Server, in some cases, you may want to reach the domain name from the e-mail address you have, that is, to obtain the domain information....

SQL Server

31 March 2022

Making a Backup of All Foreign Keys of the Related Database in SQL Server

Hello everyone, In this article, I will provide information on how to back up all Foreign Keys of the relevant database in SQL Server. In SQL Server, in some cases, you may want to back up all Foreign Keys of the relevant database. You can easily do this using the...

SQL Server

31 March 2022

How to Remove All Foreign Keys from All Tables in SQL Server?

Hello everyone, In this article, I will provide information on how to remove all Foreign Keys in all tables in SQL Server. In SQL Server in some cases you may want to remove all Foreign Keys from all tables. You can easily do this using the code below. DECLARE @Command...

SQL Server / Stored Procedures

31 March 2022

Procedure to Return Previous Week’s Failed Login List in SQL Server

Hello everyone, In this article, I will provide information about the procedure that brings the previous week’s list of failed logins in SQL Server. It is also very important for security to track failed login attempts to SQL Server. With the help of the procedure below, you can also track...