Friday, August 16, 2013

Use of COALESCE in SQL Server

 use of COALESCE in SQL Server?




declare @i varchar(500)
select @i=COALESCE(@i,RoleTitle)+','+RoleTitle from ProfileMaster

print @i

result is :

Administrator,Administrator,EO,Admin Team,Agent,Print Queue User,Client