MSSQL Query Blog

13 April 2022

Function to Remove Duplicates from Comma Separated String in SQL Server

Hello to everyone, In this article, I will try to give information about the function that removes duplicates from a comma-separated string in SQL Server. In SQL Server you may want to remove duplicates from comma separated string in some cases You can easily do this using the function below....

SQL Server

13 April 2022

Listing Active Connections in SQL Server

Hello to everyone, In this article, I will try to give information about listing active connections in SQL Server. In SQL Server you may want to list active connections in some cases. You can easily do this using the code below. select db_name(dbid) as DatabaseName, count(dbid) as NumberOfConnections, loginame as...

SQL Server

10 April 2022

Getting List of All Logins Under All Login and All Windows Group in SQL Server

Hello to everyone, In this article, I will try to give information about getting a list of all logins and all logins under all windows group in SQL Server. In SQL Server, in some cases you may want to get a list of all logins under all logins and all...

SQL Server

10 April 2022

Finding All Caps Words in SQL Server

Hello to everyone, In this article, I will try to give information about finding words with all capital letters in SQL Server. In SQL Server you may want to find words with all caps in some cases. You can do this easily using the code below. SELECT * FROM dbo.Categories...

SQL Server

10 April 2022

Getting First and Last Day of Year Dates in SQL Server

Hello to everyone, In this article, I will try to give information about getting the first and last day of the year in SQL Server. In SQL Server you may want to get the first and last day dates of the year in some cases. You can easily do this...

SQL Server

10 April 2022

Not Showing Time Expression in Date Information in SQL Server

Hello to everyone, In this article, I will try to give information about not showing the time expression in the date information in SQL Server. In SQL Server, in some cases, you may want to not show the time expression in the date information. You can easily do this using...

SQL Server / Triggers

8 April 2022

Re-Enable All Triggers in SQL Server

Hello to everyone, In this article, I will try to give information about how to reactivate all Triggers in SQL Server. In SQL Server you may want to re-enable all Triggers in some cases. You can easily do this using the code below. EXEC sp_MSforeachtable ‘ALTER TABLE ? ENABLE TRIGGER...

SQL Server

8 April 2022

Listing Indexes Linked to Tables in SQL Server

Hello to everyone, In this article, I will try to give information about listing indexes linked to tables in SQL Server. In SQL Server, in some cases, you may want to list the indexes that are linked to the tables. You can easily do this using the code below. SELECT...