insnwd.sql is not a working code ( Jan 2022)
还没有人认领这个 Issue。
评估
调研方向
打开 insnwd.sql,并在 SQL Server Management Studio 中运行它,同时检查报告的错误,尤其是语法错误以及与 Northwind 数据库和对象的冲突。重现该失败,并确定脚本需要进行哪些更改,才能在不出现所列错误的情况下执行。
由索引模型根据 Issue 内容生成。
描述
Any time I attempt to download or even copy and paste the code in to SSMS I end up with an error.
Below is the error message I receive. I am new to this and do not know how to fix this and it appears that I would have to do so because of frequent syntax errors. What do I do now?
Error Message:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
Msg 3702, Level 16, State 4, Line 13
Cannot drop database "Northwind" because it is currently in use.
Msg 1801, Level 16, State 3, Line 15
Database 'Northwind' already exists. Choose a different database name.
Msg 3726, Level 16, State 1, Line 113
Could not drop object 'dbo.Customers' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 175
There is already an object named 'Customers' in the database.
Msg 1913, Level 16, State 1, Line 193
The operation failed because an index or statistics with name 'City' already exists on table 'dbo.Customers'.
Msg 1913, Level 16, State 1, Line 195
The operation failed because an index or statistics with name 'CompanyName' already exists on table 'dbo.Customers'.
Msg 1913, Level 16, State 1, Line 197
The operation failed because an index or statistics with name 'PostalCode' already exists on table 'dbo.Customers'.
Msg 1913, Level 16, State 1, Line 199
The operation failed because an index or statistics with name 'Region' already exists on table 'dbo.Customers'.
- 主要语言
- PowerShell
- 星标
- 11.2k
- 派生
- 9.1k
- 平均合并
- 2 天 7 小时
- 30 天内合并 PR
- 14
贡献指南
这个仓库没有索引到贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
microsoft/sql-server-samples 的其他 Issue
-
难度 1/5 1 小时以内 新手友好度 85/100
microsoft/sql-server-samples#1499 ·
-
难度 1/5 1-3 小时 新手友好度 76/100
microsoft/sql-server-samples#1495 · 3 个 reaction ·
-
难度 1/5 1 小时以内 新手友好度 62/100
microsoft/sql-server-samples#1341 ·
-
难度 1/5 1 小时以内 新手友好度 64/100
microsoft/sql-server-samples#276 ·
-
难度 1/5 1 小时以内 新手友好度 35/100
microsoft/sql-server-samples#1497 ·
查看 microsoft/sql-server-samples 的全部 Issue
相似的 Issue
-
[Documentation Request] vLLM kv_load_failure_policy doesn't apply to load failures in L2 adapters 未关闭
难度 2/5 1-3 小时 新手友好度 65/100
-
难度 2/5 1-3 小时 新手友好度 65/100
-
DATABASE_URL=pglite:memory: creates a directory named 'memory:' instead of an in-memory database 未关闭
难度 2/5 1-3 小时 新手友好度 75/100
BuilderIO/agent-native#5730 · 1 条评论 ·
-
难度 2/5 1-3 小时 新手友好度 65/100
duckdb/duckdb-wasm#2258 ·
-
难度 2/5 1-3 小时 新手友好度 70/100
supabase/agent-skills#602 ·