Share
ReportFrom the Query Tool, I am not able to read the Transaction table. SELECT * FROM Transaction prompts an error. I am able to read all other tables.
*This post is locked for comments
You’re offline. This is a read only version of the page.
140
From the Query Tool, I am not able to read the Transaction table. SELECT * FROM Transaction prompts an error. I am able to read all other tables.
*This post is locked for comments
you need to surround the transaction table name with brackets. Like:
select * from [transaction].
transaction is a reserved word in Microsoft SQL server (all versions)
make it [Transaction]
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
