我如何重构这个查询,使其不存在COALESCE或ISNULL?我能把它改成大小写吗?有没有其他方法可以重构它?SELECT * FROM MockDb WHERE COALESCE(Column2,0) = @value2 AND COALESCE(Column4,0) = @value4 AND
COALESCE(Column5,0) = @
您好,朋友们,我对sql server有一点疑问,如何处理目标表不匹配的记录,用NA.please替换,告诉我如何在sql server中解决这个问题。[id]= CASE WHEN coalesce(ltrim(rtrim(stag.[id])),'') = '' THEN 'NA' ELSE ltrim(rtrim(stag.[descr]= CASE WHEN coalesce(ltrim(rtrim(stag.[de
:MI:SSOF'), cast(' ' as varchar)) ||E'\t'||
(CASE WHEN AG.AGOF_SIT = '1' THEN (CASE WHENGROUP BY AG.AGOF_CODIGO, AG.AGOF_DESCRICAO, AG.AGOF_DESCRICAO, AG.AGOF_DATAI, AG.AGOF_DATAF, (CASEWHEN AG.AGOF_SIT = '1' THEN