How can I query a table literally called [tbl] with the square brackets in its name?
如何查询名称中有方括号的表[tbl] ?
I'm trying
我试着
select * from [[tbl]]
But that doesn't work. Nor does
但这并不工作。也没有
select * from [\[tbl\]]
How else would I escape the [s?
否则我怎么能逃过这个关呢?
1 个解决方案
#1
4
Through trial and error, I discovered you have to double the number of closing ]s only. i.e.
经过反复试验，我发现你必须把收款单的数量加倍。即。
select * from [[tbl]]]
#1
4
Through trial and error, I discovered you have to double the number of closing ]s only. i.e.
经过反复试验，我发现你必须把收款单的数量加倍。即。
select * from [[tbl]]]