Burman@cool blog's(ASP.NET,SQL SERVER,JavaScript,XML,sharepoint,WCF,SSIS)
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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)