microsoft / microsoft/sql-server-samples
WWI DW tables named with reserved keywords
Open
@jodebrui is already working on this.
Since Feb 15, 2017.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Hi,
Fact.Order and Fact.Transaction in the WWI DW data model use reserve keywords for their names. This causes undelimited queries to fail against them.
For example :
select * from fact.order
returns the error :
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'order'.
The same error is given when querying Fact.Transaction. To query each requires that the table name is delimited by square brackets.
Can these table names be modified to not use reserve keywords?
Thanks.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.