在 SQL Server 中报告错误的正确位置在哪里?

发布于 2024-09-16 02:44:09 字数 764 浏览 5 评论 0原文

我在 SQL Server 2008 中发现了一个相当微不足道的错误。

但是,当我访问 https 时,我想向 Microsoft 报告此问题://support.microsoft.com/ 我意识到我可能需要花费 300 加元来报告此问题。

有没有一个地方可以让我报告这个错误而不需要花费我任何钱?


以下是该错误的示例:

有效:

USE [msdb]  
(SELECT * FROM msdbms)

失败,并出现 “关键字“order”附近的语法不正确。”

USE [msdb]  
(SELECT * FROM msdbms ORDER BY dbms)

此外,如果我错了,这不是一个错误,可以解释为什么不吗?

编辑
我已将其添加到 Microsoft Connect

I have found a fairly insignificant bug in SQL Server 2008.

I would like to report this to Microsoft, however, when I went to https://support.microsoft.com/ I realized that I may need to spend $300 CAD to report it.

Is there a place where I can report this bug without it costing me any money?


Below is a sample of the bug:

Works:

USE [msdb]  
(SELECT * FROM msdbms)

Fails with "Incorrect syntax near the keyword 'order'."

USE [msdb]  
(SELECT * FROM msdbms ORDER BY dbms)

Also, if I am incorrect and this isn't a bug can it be explained why not?

EDIT
I've added this to Microsoft Connect

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(6

十秒萌定你 2024-09-23 02:44:26

我注意到我工作场所的 sql 存在错误。我学的是IT管理专业。
问题是鼠标指针在矩形中
如果指针停留在那里<•••>在这个标志之后
有些东西是不同的。
我注意到这种差异取决于

  1. 使用手指在触摸屏上
  2. 使用鼠标单击屏幕

I noticed bug in sql in my work place. I studied IT in management.
Problem is Pointer of mouse in rectangle
If pointer is held there <•••> after this sign
something is different.
I noticed this difference depending on this

  1. using finger on touchschreen
  2. using mouse to click on screen
秋凉 2024-09-23 02:44:24

更有趣或更臭的错误/功能是通过运行以下命令来获得错误排序的列表:

USE [msdb]  
select * from (SELECT top 100 percent * FROM msdbms order by 1 desc) t

因为,显然,按照设计,按前 100% 进行排序是行不通的。有趣的是,即使你没有从中获得任何东西,你也可以指定 order by 。

这更多的是一个“查看”评论,并不是真正的错误。但值得一提的是。

The funnier or smellier bug/feature would be to get a wrongly sorted list by running the following:

USE [msdb]  
select * from (SELECT top 100 percent * FROM msdbms order by 1 desc) t

Because, apparently, by design, sorting with top 100 percent doesn't work. And the funny part is that you are allowed to specify order by even though you're not gaining anything by it.

It's more of a 'view' comment and it's not really a bug. But it's interesting to mention.

北座城市 2024-09-23 02:44:22

看起来 UserVoice(正如其他人建议的那样)也已经退役了!报告错误的新位置似乎是 https://learn.microsoft.com /en-us/answers/index.html

It looks like UserVoice (as others suggested) has been retired also! The new place to report bugs seems to be https://learn.microsoft.com/en-us/answers/index.html

青春如此纠结 2024-09-23 02:44:20

Connect 是常用站点。

另一个与括号相关的问题

Connect is the usual site.

Another parentheses related issue.

人生百味 2024-09-23 02:44:17

您可以在 sql server connect 站点 https://connect.microsoft.com/SQLServer 报告

错误,这里有 2 个解决方法,因为你真的不需要括号

USE [msdb]  
SELECT * FROM msdbms ORDER BY dbms

USE [msdb]  
select * from 
(SELECT * FROM msdbms) x
ORDER BY dbms

you can report bugs at the sql server connect site https://connect.microsoft.com/SQLServer

however, here are 2 workarounds because you really don't need the parenthesis

USE [msdb]  
SELECT * FROM msdbms ORDER BY dbms

USE [msdb]  
select * from 
(SELECT * FROM msdbms) x
ORDER BY dbms
丶情人眼里出诗心の 2024-09-23 02:44:15

现在,由于 GDPR,Connect 即将停用,他们已经迁移了所有内容将内容(据说是!)连接到 Azure 反馈论坛下的 UserVoice。 Bug/issues/product-feedback 应定向到那里

有趣的是,他们说“如果您遇到技术问题,请在 StackOverflowMSDN。"不确定他们所说的“技术问题”是什么意思,以及它是否是“错误”的同义词。但是,鉴于 Connect 在其存在期间用于提交错误,因此,这个新位置(他们已从 Connect 迁移了 4000 个错误报告)将继续是此类错误报告的正确位置,这是理所当然的……但我'我没有 MVP 或“内部人士”或诸如此类的东西,所以希望更接近消息来源的人可以验证这一点。

Now that Connect is being retired thanks to GDPR, they've migrated all Connect content (supposedly!) to UserVoice under the Azure feedback forums. Bugs/issues/product-feedback should be directed there.

Interestingly enough, they say "If you have a technical issue, please open a post on StackOverflow or MSDN." Not sure what they mean by "technical issue" and whether or not it's a synonym for "bug". But, given that Connect was used for filing bugs while it was alive, it stands to reason that this new location, wherein they've migrated 4000 bug reports from Connect, would continue to be the correct place for such... but I'm no MVP or "insider" or whatnot, so hopefully someone closer to the source can verify this.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文