How to find all tables with primary key SQL Server

How to find all tables without primary key SQL Server? Read more →

How to return the character values based on ASCII character number values

I want to view the character values based on the ASCII character number values Read more →

How to INSERT INTO EXEC with extra column

The truth about INSERT INTO EXEC and adding extra data Read more →

How to use STRING_AGG to concatenate strings with grouping

Question: Below is table and expected result. What is the query to achieve this result Table : Test ID LOT 7065161 4 7065212 1 7065212 4 7065203 1 7065203 2 7065203 3 Expected Result of query ID LOT 7065161 4 7065212 1_4 7065203 1_2_3 Answer: Previous to SQL Server 2017 - I use to use the COALESCE function , but since SQL Server 2017 - a new function was introduced : STRING_AGG . According to MS documentation "Concatenates the values of string expressions and places separator values between them. The separator is not added at the end of string" There... Read more →

How to check if SQL Server Agent is running using t-sql

Question: I want to check if SQL Server Agent is running using t-sql. I know I can check through the services.msc or other methods such as Powershell scripts to report on the SQL Server Agent status , but the requirement is to extract this information via t-sql. Do you have a script using t-sql to get the SQL Server Agent Status? Answer: If you check the SQL generic Refresher program in the sysprocesses list , it is possible to establish the SQL Server Agent status through t-sql. The SQL Generic Refresher is an app program. When the SQL Server Agent... Read more →