有用(困难)SQL 脚本库 [英] Library of Useful (Difficult) SQL scripts

问题描述

有谁知道我在哪里可以找到一个包含常见但困难(不同寻常)的 SQL 脚本示例的库.我说的是那些您在文档中找不到但确实需要经常完成诸如查找重复项等任务的示例.

Does anyone know where I can find a library of common but difficult (out of the ordinary) SQL script examples. I am talking about those examples you cannot find in the documentation but do need very often to accomplish tasks such as finding duplicates etc.

手边有这样的东西会节省很多时间.

It would be a big time saver to have something like that handy.

谢谢大家，我认为这正在变成一个很好的快速参考.描述性越强，效果越好，所以如果你看到你的方式打开了 - 请编辑并添加一些可以找到的描述.非常感谢那些已经这样做的人！

Thanks everyone, I think this is turning into a great quick reference. The more descriptive the more effective it would be, so please if you see your way open - please edit and add some descriptions of what one could find. Many thanks to those that have already done so!

推荐答案

您可能会发现 thisLessThanDot 上的 wiki 很有用，大部分是由 Microsoft SQL MVP Denis Gobo 编写的.

You may find this wiki on LessThanDot useful, for the most part, it is by Denis Gobo, Microsoft SQL MVP.

该 wiki 包括 100 多个 SQL Server 编程技巧，我认为列表太长，无法包含在此处，但是，有一个 综合索引.

The wiki includes 100+ SQL Server Programming Hacks, the list is, I think, too long to include here, however, there is a comprehensive index.

也可从同一站点获得:SQL Server Admin Hacks.

Also available from the same site: SQL Server Admin Hacks.

这篇关于有用(困难)SQL 脚本库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！