Post
Ask Question

How use Coalesce in sql server

Hi friends, In this small article we can learning how row data in column format . For example
 
srNo        Language
1              C#
2              c-sharpCorner
3              code-project
4             stackoverflow
 
after this query our data show like this  C#,c-sharpCorner,code-project,Stackoverflow.
how can declare:
  1. SELECT COALESCE(NULL, NULL, NULL, GETDATE())  
 
  1. DECLARE @DepartmentName VARCHAR(1000)   
  2.   
  3. SELECT @DepartmentName = COALESCE(@DepartmentName,'') + Name + ';'    
  4. FROM tablename   
  5. WHERE (GroupName = 'Language')   
  6.   
  7. SELECT @DepartmentName AS DepartmentNames 
  8.