microsoft / microsoft/sql-server-samples
instnwnd.sql syntax error with SSMS 18.4
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
I download instnwnd.sql and load it into SSMS 18.4. Attempt to run the script.
I get the following error:
Msg 102, Level 15, State 1, Line 536
Incorrect syntax near '0x151c2f000200...
Line 536 looks like this:
INSERT "Categories"("CategoryID","CategoryName","Description","Picture") VALUES(1,'Beverages','Soft drinks, coffees, teas, beers, and ales',0x151C2F000...
I tried this same file with Azure Data Studio and the script runs with no errors, so the download was successful.
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.
Research direction
Start with instnwnd.sql around line 536 and reproduce the syntax error in SSMS 18.4. Compare the INSERT statement and its binary value with how Azure Data Studio parses it; done means the downloaded script runs successfully in SSMS 18.4 without the reported error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100