添加WHERE子句 [英] Adding a WHERE clause

问题描述

嗨大家都在那里。

我试图写这个陈述但是它有点不起作用。

Chill60昨天帮助我，但现在我试图添加一个WHERE子句，但 EXCEPT 正在加下划线。我尝试了所有方括号但是没有把它弄好。

一个想法？

Hi Everybody out there.
Am trying to write this statement but itz kind of not working.
Chill60 helped me out yesterday but now am tryiny to add a WHERE clause to but the EXCEPT is being underlined. I' ve tried all brackets but ain't getting it right.
An idea?

SET @Dynamictbl = N'SELECT DISTINCT [Projektdefinition DB] AS Zugänge
 FROM ' + @Table_Name + ' WHERE [Geschäftsbereich] = PB '
 ' EXCEPT
 SELECT DISTINCT [Projektdefinition DB] AS Zugänge
 FROM ' + @Table_Name2 + ' WHERE [Geschäftsbereich] = PB'

推荐答案

尝试：

Try:

SET @Dynamictbl = N'SELECT DISTINCT [Projektdefinition DB] AS Zugänge
 FROM ' + @Table_Name + ' WHERE [Geschäftsbereich] = ''PB''' + 
 ' EXCEPT
 SELECT DISTINCT [Projektdefinition DB] AS Zugänge
 FROM ' + @Table_Name2 + ' WHERE [Geschäftsbereich] = ''PB'''

或在除语句之外删除[']。

这篇关于添加WHERE子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！