Create a Comma Separated List with SELECT in SQL Server by SQLYoga Guide
Today, I encountered a situation where I needed to display all related data in a comma-separated list using a SELECT statement. Up until now, I have been using a scalar function that utilizes COALESCE() to achieve this. However, I discovered a fantastic solution that allows us to generate a comma-separated list without needing a scalar function. Let’s dive into it with SQLYoga guide.
Exploring Table Size Measurement in SQL Server with sp_MSforeachtable by SQLYoga Guide
Are you looking to delve into the nitty-gritty details of your SQL Server database? Perhaps you’re seeking insights into how much space each table occupies? Look no further! In this guide, brought to you by SQLYoga, we’ll walk you through a handy tool for measuring table size in SQL Server using the sp_MSforeachtable procedure.
REPLICATE() Function in SQL Server by SQLYoga Guide
Are you struggling with ensuring uniformity in numeric data stored in your SQL Server database? Fear not! SQLYoga brings you an insightful guide on mastering the REPLICATE() function, your solution to standardizing numeric data effortlessly.
SQLYoga: Adding Computed Columns in SQL Server
A scenario that required me to add one calculated column came up today. When a column is computed, it can be used in queries just like any other column and allows us to change one or more columns from the same table.