oracle與sqlsever的區別
區別一
oracle字符之間連接用||
sqlserver字符之間連接用+
區別二
oracle字段重命名用as
sqlserver字段重命名用=
區別三
oracle判空用nvl
sqlserver判空用isnull
區別四
oracle多列合并成一列
select
assid,
LISTAGG(name,' ') within group (order by name ) as assconbilename
from temp_gl_fzhs_view
group by assidsqlsever多列合并成一列
SELECT
assid,
assconbilename((select ','+name FROM temp_gl_fzhs_view WHERE assid = fz.assid for xml path('')),1,1,'')
FROM temp_gl_fzhs_view fz
group by assid
