假设我想使用如下代码:
select 'Response Status Code', 'Client Response Status Code'
from TC_Sessions (NOLOCK)
WHERE StartDate BETWEEN '05-15-2012' AND '06-01-2012'
AND SupplyID = 3367
如何在SQL Server中实现这一点?
谢谢!
假设我想使用如下代码:
select 'Response Status Code', 'Client Response Status Code'
from TC_Sessions (NOLOCK)
WHERE StartDate BETWEEN '05-15-2012' AND '06-01-2012'
AND SupplyID = 3367
如何在SQL Server中实现这一点?
谢谢!
select [Response Status Code], [Client Response Status Code]
from TC_Sessions (NOLOCK)
WHERE StartDate BETWEEN '05-15-2012' AND '06-01-2012'
AND SupplyID = 3367
把名字放在方括号里.
但是,如果可能的话,最好避免在名称中使用空格.这只会给你带来更多的工作...