There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you. So lets start one by one. 1) LEN :- By the name it is clear that LEN function give length of the parameter For example :- DECLARE …
Problem :- Most of the time we have one master table and one child table which content reference of master table. We have to fetch all the child column as comma separated for master table column. for example I have a product category table and product table. We want all the product as a …