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 →

How to execute a SQL batch multiple times with GO

Question: I'd like to execute a batch sql statement through SQL Server management studio multiple times and avoid using a loop statement or other similar constructs . I'm doing some testing requiring multiple returns of recordsets and would like a simple approach - for ad hoc queries Answer: Looking at the SQL Server documentation for the sql server utility GO - indicates the syntax is GO [count]. This means the queries triggered as part of the batch executed will execute the amount of times listed after GO. By default it's 1 , but if you specify a positive integer -... Read more →