Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Blog Author Picture

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

Subscribe to my newsletter and never miss my upcoming articles

How to replace the first instance of the string in T-SQL?

Jul 6, 20221 min read

You can use the combination of stuff, charindex and len function to replace the first occurrence of the string. declare @database_name...

How to enable SQL Server database for publication

Jun 14, 20221 min read

SQL Server Replication · Problem: I have configured the distributor and then trying to create a publication on the publication server using...

What is the difference between stored procedure and function in SQL?

May 22, 20221 min read

Stored procedure can call a function. But function can not call a stored procedure. Stored procedure can use temporary tables and table variables....

How to concatenate multiple rows into a single string in SQL?

May 16, 20222 min read

SQL interview questions and answers #11 · Write a SQL query to concatenate multiple rows into a single string? USE TestDB; GO DROP TABLE IF EXISTS...

How to concatenate multiple rows into a single string in SQL?

How to de-group the data in SQL?

May 15, 20221 min read

SQL interview questions and answers #10 · Write a SQL query to de-group the data and provide the output as below. Let us first create the test data to...

How to de-group the data in SQL?

How to find which command has failed in SQL Server Replication?

May 14, 20221 min read

Why command has caused an issue in replication? · To find out the list of replicated transaction, query the MSrepl_transactions table in distribution...