MY SQL: GROUP_CONCAT function concatenates values within each group defined by GROUP BY clause. Syntax GROUP_CONCAT([DISTINCT] exp [ORDER BY sorting] [SEPARATOR ‘sep’]) Quick Example SELECT
Tag: Microsoft SQL Server
Visual Studio – Database Project Not Loading
Have you ever created a Database project and after some time you are not able to load it in the Visual Studio? Probably you might
Cannot drop database because it is currently in use.
This is a very common error when DROP Database is command is executed and the database is not dropped. The following commands will raise above
COALESCE with DISTINCT in SQLServer
If you want comma separated values from columns it is so simple. Use COALESCE function provided by SQL Server. DECLARE @csv varchar(max) select @csv =