blocks|key|1390748|text|我不是律师，但据我所知：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1390749|除非您有明确的书面“雇佣工作”协议，或者可以证明存在对“雇佣工作”的相互理解，否则他将在其法律权利范围内限制该代码的使用。|1390750|“受雇工作”基本上是指个人在“受雇工作”安排下创造的任何东西，都是雇用他们的人的财产。如果没有这样的协议，新创作的作品将自动获得作者的版权。我相信任何由雇员(不是分包商)创作的作品都会自动被认为是“受雇作品”。|1390751|当然，你不能对这些想法进行版权保护，只能对这些想法进行具体的表达。|1390752|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I am not an attorney, but from what I understand:

Unless you had an express "work for hire" agreement in writing, or could prove that a mutual understanding of "work-for-hire" existed, then he would have been within his legal right to limit the use of that code. 

"Work for hire" basically means anything created by an individual while under a "work-for-hire" arrangement, is immediately the property of the person hiring them. Without such an agreement, new work created is automatically copyrighted to the individual writing it. I believe any work created by an employee (not sub-contractor) is automatically considered "work for hire".

Of course you cannot copyright ideas, only a specific expression of those ideas.

blocks|key|1175305|text|一如既往，如果你真的很担心，那就去问律师吧。我们是开发人员。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1175306|如果我看到这样的内容，并且查询不是太复杂，我会自己重写它(可能严格使用他的查询来确定数据库模式，但仅此而已)。|1175307|在这一点上，你将会更新别人的work...not。|1175308|至于他的query...if在创作时还没有签订合同，我认为强制执行版权有点奇怪。|1175309|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

As always, if you're truly worried about it then ask a lawyer. We're developers.

If I saw something like that and the query wasn't anything overly complicated, I'd re-write it myself (possibly using his query strictly to figure out the database schema, but that's it).

At that point, you'd be updating your work...not somebody else's.

As for his query...if there was no contract signed at the time of the work, I think it'd be a little flaky to enforce the Copyright.

blocks|key|1390846|text|他要500美元才能把2009年变成2010年？哦，天哪，太扯了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1390847|今年付给他500美元，并告诉他您希望查询以学年为参数。看看他知道这将是他最后一次为你工作后的反应。|1390848|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

He charges $500 to change 2009 to 2010? Oh man what a rip.

This year pay him his $500 and tell him you want the query to take the school year as a parameter. See how he reacts to knowing this will be his last time working for you.

blocks|key|1390929|text|我认为你需要看的不是代码，而是个人编写代码时所依据的合同。通常，在任何类型的编程活动中，都会清楚地指示项目的源代码/目标代码的所有权。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1390930|如果这不在原始合同中，那么我会确保它在这一份中。|1390931|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I think you'll need to look not at the code but at the contract under which the individual wrote the code. Normally in any kind of programming activity there is a clear indication of the ownership of the source code/object code for the project.

If that wasn't in the original contract then I'd make sure it was in this one.

blocks|key|1175524|text|找一个从未见过敲诈勒索者的代码的人来检查表结构，并以一种纯净的方式派生一个等价的查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1175525|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Find someone who has never seen the extorter's code to inspect the table structure and derive an equivalent query in a cleanroom fashion.

blocks|key|1391042|text|我的第一个问题是“当你去年付钱给他时，你和开发人员的合同上写了什么？”或者，我会去和学校系统的律师谈谈。如果有合同的话就拿上去年的合同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1391043|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My first question would be "What did the contract you had with the developer say when you paid him last year?" Or, I'd go talk to the attorney for the school system. And take the contract from last year if there is one.

blocks|key|1175680|text|可以，SQL查询可以受版权保护。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1175681|你真正需要问的问题是-他真的拥有版权吗，或者他只是说他拥有。这将取决于编写查询时所依据的合同条款。|1175682|编辑:我想修改我的答案-你可以用它做任何你想做的事情(我不是律师！)，只要不涉及奇怪的合同。|1175683|案例1:他卖给你的.sql文件是一个“程序”--+.sql文件本身就是一个程序，你可以随心所欲地修改它--如果你买了任何应用程序，你可以用十六进制编辑器打开它，然后改变它的位置。没有EULA禁止这一点。|1175684|案例2:他把.sql文件作为源代码卖给你--他卖给你源代码，这意味着源代码就是你从他那里买来的，你也可以修改它，因为你只是在修改你买的东西。|1175685|人们太沉迷于这样一个事实，即你可以“查看.sql文件的源代码”--它可以是一个程序，也可以是一个源文件，这取决于合同，无论哪种方式，你都可以修改它。版权保护人们免受未经授权的传播，而不是为了内部使用而修改。|1175686|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Yes, SQL queries CAN be protected by copyright.

The question you really need to be asking is - does he actually own the copyright, or is he just saying he does. This would depend on the terms of the contract under which the query was written.

Edit:
I want to modify my answer - you can do what you wish with it (I am not a lawyer!), as long as there is no strange contract involved.

Case 1: He sold you the .sql file as a "program" - the .sql file itself is the program, and you can modify it however you want - same with if you buy any application you can open it with a hex editor and change bits around. There is no EULA prohibiting this.

Case 2: He sold you the .sql file as source code - he sold you the source meaning the source was what you bought from him and again you can modify it as you're just modifying what you bought.

People are getting too caught up in the fact that you can "view the source" of a .sql file - it's either a program or it's a source file depending on the contract, and either way you can modify it. Copyright protects people from unauthorized distribution, not modification for internal use.

blocks|key|1391224|text|它是一个SQL查询的事实是转移视线。它是源代码和知识产权，就像它被编译成可执行文件一样。正如其他人已经说过的那样，对您使用软件的任何限制主要取决于您的协议条款。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1391225|我注意到他的评论是这样说的：|1391226|//+This+code+MAY+NOT+BE+USED+without+the+expressed+written+consent+of+|code-block|syntax|javascript|1391227|这并不意味着修改它，而且如果你修改了它，那么你也可以争辩说你没有使用他的代码。|1391228|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The fact that it is a SQL query is a red herring. It is source code and intellectual property just like if it was compiled into an executable. As others have already said, any limitations on your use of the software depends mostly on the terms of your agreement.

I will observe that his comment says:

<pre><code>// This code MAY NOT BE USED without the expressed written consent of 
</code></pre>

Which says nothing of modifying it, plus if you modify it then you could also argue that you aren't using his code.

blocks|key|1391268|text|找其他人帮你重写查询(或者自己做)，永远不要再使用他的代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1391269|你不需要用他的代码。|1391270|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Find someone else to rewrite the query for you (or do it yourself) and never use his code again.

You don't have to use his code.

blocks|key|1175874|text|如果我是你，我会写一个完整的描述查询需要做什么，包括所有的表，字段名等，并张贴在这里。这里肯定有人能够编写一个新版本的查询，而不是您的开发人员的版权，您可以每年编辑它，使其成为您的核心内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1175875|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If I were you, I would write a full description of what the query needs to do, including all the tables, fieldnames etc., and post that here. Someone here is bound to be able to write a new version of the query that is not copyright your developer, and you can edit it each year to your hearts content.

blocks|key|1175916|text|从头开始编写您自己版本的“应用程序”。能有多难呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1175917|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Write your own version of the "application" from scratch. How hard can it be?

blocks|key|1176064|text|我不是律师，但如果你对此不确定，你可以在他的工作合同中添加一行，说明他在工作时间、在工作计算机上等编写的所有代码都属于雇用他的公司。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176065|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'm not an attorney, but if you're unsure about it you can add line in his work contract saying that all his code written during work hours, on work computers, etc. belongs to the company hiring him.

blocks|key|1391589|text|我建议您发布一个不同的问题:考虑到我们学生管理系统的表结构，SO社区会想出什么SQL查询来导出任何给定年份的学生列表？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1391590|这将使您的原始问题变得有趣，但我与您手头的任务相关，因为您将有一个社区提供的解决方案，可能会多次更高的性能和更容易维护:)|1391591|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I suggest you post a different question: given this and that table structure of our student management system, what SQL query would the SO community come up with to export the list of students for any given year?

This will make your original question interesting, but irelevant for your task at hand, since you'll have a community provided solution, probably times and times more performant and easier to maintain :)

blocks|key|1176176|text|我很乐意为你们的学区工作。显然，你的承包商可以在他们的评论中加入任何他们喜欢的条件，你的第一个冲动将是尊重他们，而不是查看合同并确定实际条件是什么。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176177|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'd love to do work for your school district. Apparently your contractors can stick whatever conditions they like into their comments and your first impulse will be to honor them rather than looking up the contract and determining what the actual conditions are.

blocks|key|1176256|text|棘手的问题是:假设您不能合法地更改查询，那么就改为更改数据。创建数据库的副本，更新年份并使用2009年的查询导出数据。无论如何，至少在我的国家，版权所涵盖的内容有一个较低的门槛。一个简单的查询"select+foo，bar，bla，bla+from+foobar+order+by+foo，bar“肯定不合格。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176257|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Tricky way around: Assuming you cannot legaly change the query, change the data instead. Create a copy of the database, update the year and export the data with the 2009 query. Anyway, at least in my country, there is a lower threshold for what is covered by copyright. A simple query a'la "select foo,bar,bla,blub from foobar order by foo, bar" surely would not qualify.

blocks|key|1176322|text|你从来没有说过你在哪里，所以我们给你的任何建议都是无用的。在不同的司法辖区有不同的法律。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176323|如果你在美国，打电话给你当地的律师协会，要求推荐一个从事软件版权工作的人，并相信那个人告诉你的，而不是你读到的任何东西。如果你在另一个国家，找出相同的信息。|1176324|作为一名不是任何律师的美国公民，有几件事需要考虑。|1176325|你从来没有告诉我们这个查询有多复杂。不可能对某些东西的唯一合理实现进行版权保护。如果它很简单，就用一种简单的方式重写它。如果它很复杂，那么查询可能不是严格意义上的函数式查询，毫无疑问，它具有一定的创造性。在这种情况下，你应该用不同的方式重写它，或者雇佣某人。|1176326|你应该能够找到比继续支付500美元/年更便宜地重写查询的人，而且应该不难找到比原始开发人员更有道德的人。|1176327|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

You never said where you were, so any advice we could give you is useless. There are different laws in different jurisdictions.

If you're in the US, call your local Bar Association, ask for a referral to somebody who works with software copyrights, and trust what that person tells you, not anything you read on SO. If you're in another country, find out the equivalent.

Speaking as a US citizen who is not a lawyer of any sort, there's a few things to consider.

You never told us how complicated the query was. It's impossible to copyright the only reasonable implementation of something. If it's straightforward, just rewrite it in a straightforward manner. If it's complicated, the query is probably not strictly functional, and there is doubtless some creativity in it. In that case, you should rewrite it in a different manner, or hire somebody.

You should be able to find somebody who'll rewrite the query cheaper than continuing to pay $500/year, and it shouldn't be hard to find somebody more ethical than the original developer.

blocks|key|1176400|text|这里有许多选项，其中之一是创建一个黑盒替代品。这听起来像是一个很好理解的问题，您可以为其编写一个简短的需求文档。我建议您包含参数化变量选项的选项，例如有问题的年份(!)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176401|更重要的是，我建议您在替换代码中避免SQL+Injection和类似的攻击。在我看来，如果有人创造了这样的摇钱树，他们完全专注于榨取你的钱，而不是生产你真正需要的高质量的一次性解决方案。|offset|length|1176402|考虑到你的需求文档，你的建议，你有一个高质量的数据库管理系统，这样你就不会被‘黑客’，你应该在一个坚实的位置来编写一个功能替代。|1176403|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL_injection^0|0|I|D|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

One of your many options here is to create a black box replacement. This sounds like a well-understood problem for which you can write a short requirements document. I would recommend that you include the option to parameterize variable options such as the year in question (!).

More importantly, I would recommend that you make <a href="http://en.wikipedia.org/wiki/SQL_injection" rel="nofollow noreferrer">SQL Injection</a> and similar attacks impossible in your replacement code. To my mind, if someone has created a cash cow like this, they are focused entirely on milking you for the money and not so much on producing the quality one-time solution that you really need.

Given your requirements document, your recommendation that you have a quality database management system so that you don't get 'hacked', you should be in a solid position to write a functional replacement.

blocks|key|1176446|text|查看Aharonian+v.+Gonzales。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1176447|基本上，您不能复制应用程序的源代码，但只要不侵犯源代码本身的版权，您就可以创建功能相似的应用程序。|1176448|本质上，您可以重新创建SQL查询，但不能直接复制它们。|1176449|不过，如果你有更多的顾虑，可以和律师谈谈。|1176450|entityMap|0|LINK|mutability|MUTABLE|url|http://patentlaw.typepad.com/patent/2006/02/court_upholds_d.html^0|2|L|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

Checkout <a href="http://patentlaw.typepad.com/patent/2006/02/court_upholds_d.html" rel="nofollow noreferrer">Aharonian v. Gonzales</a>.

Basically, you cannot copy the source code of an application, but you can create an application that is functionally similar so long as that does not infringe the copyright of the source code itself.

In essence, you can recreate the SQL queries, but you can't copy them directly.

Still, talk to a lawyer about it if you have additional concerns.

blocks|key|1176490|text|这取决于校区和完成工作的人之间的合同。如果是Work+for+Hire合同(可能是最常见的)，那么签约人(学校)拥有作品。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1176491|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Work_for_hire^0|M|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

It depends on the contract between the school district and the person who did the work. If its a <a href="http://en.wikipedia.org/wiki/Work_for_hire" rel="nofollow noreferrer">Work for Hire</a> contract (probably the most common), then the contractee (school) owns the work.

blocks|key|1392060|text|获取SQL文件，并将其更改20%25。添加格式，添加别名等等。如果它改变了20%25，即使他试图上法庭，也没有法官会说它是一样的。这不是版权，所以不用担心。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392061|如果他在家里写代码，使用自己的所有工具，那么他就可以为权利的主张而战。如果他在开发SQL查询时使用了任何学校材料，那么这是学校的权利。|1392062|我在工作中一直在处理这些废话，因为我是自由撰稿人，并且有一份全职的编程工作。|1392063|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Take the SQL file, and change it by 20%. Add formatting, add aliases, whatever. If it's changed by 20% even if he tries to go to court no judge will claim its the same. It's not copyright, so don't worry about it.

If he wrote the code while at home, using all his own tools, then he could fight for the claim of rights. If he used ANY school materials when developing the SQL query, then it's the right to the school.

I deal with this crap all the time at work because I free lance and have a full time programming job.

blocks|key|1176604|text|这是一个充斥着软件工程师的论坛，他们对编码了解很多，但对法律问题知之甚少。你最好咨询律师，而不是冒着在这里收到坏建议的风险。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176605|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This is a board filled with Software Engineers who know a lot about coding and little about legal issues. It is better you consult a lawyer rather than risk receiving bad advice here.

blocks|key|1176641|text|是不是说你不能在网上发布他的代码？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176642|在这里发布！|1176643|然后有人对其进行更改，并在没有版权的情况下发布更改后的版本。并使用它。|1176644|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Does it say you cannot publish his code online?

Publish it here!

Then someone change it and publish the changed version without the copyright.. and use that.

blocks|key|1392194|text|事实上，我对这个问题的一些态度感到有点惊讶。程序员最初被请来是因为没有人能解决这个问题。解决方案可能很简单，也可能不容易，但没有人能做到，而他做到了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392195|然后，他每年都会被召回做维护工作。虽然改变年份并不完全是火箭科学，也许其他人会建议参数，但他并没有被要求(我假设)。是不是有人为了争论而为程序员写了一份他不遵守的规范？还是有人对他说：“修好它。多少钱?500美元?酷，快点。哦，明年再来维护它吧”？|1392196|这里的大部分愤怒似乎是围绕着他解决的问题的简单性，但这肯定不是重点？他解决了实际问题，确保每年都能运行，并获得了约定的补偿。我的数学很糟糕，但我怀疑有些人可以编写应用程序来进行快速傅立叶变换，而不会出一身汗。而是因为他们发现，如果他们对“解决问题”收取很少或不收取任何费用，这很容易。|1392197|关于版权的问题。这里的很多帖子都是以“我不是律师”开始的。不，我怀疑也不是最初的程序员。他(笨拙地)试图保护自己，我同意其他人的观点，即它要么不值得写在纸上，要么需要重写，而不查看或使用代码，或者这里的一些其他建议。而不是为了谋生而敲打人。|1392198|好了，现在记下我的反对意见吧。|1392199|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Actually I am a bit surprised at some of the attitudes to this question. The programmer was initially brought in as no one else could solve the problem. The solution may or may not have been easy but no one else could do it and he could and did.

He then gets called back in every year to do maintenance. While the changing the year is not exactly rocket science and maybe someone else would have suggested parameters he was not asked to (I assume). Did someone for argument's sake write a specification for the programer which he didn't adhere to? Or did someone say to him 'just fix it. How much? $500? Cool, hurry up. Oh and come back next year and maintain it please"?

Much of the wrath here seems to be around the simplicity of the problem he solved, but surely that is not the point? He solved the actual problem, ensured it all ran each year and got an agreed recompense. My maths is awful, but I suspect there are people who can write applications to do fast Fourier transforms without breaking into a sweat. But because they find it easy should they charge little or no money for "solving the problem".

The point about the copyright. Well, many of the post here started with "I AM NOT A LAWYER". No, and neither I suspect was the original programmer. He (hamfistedly) tried to protect himself and I agree with others that it is either not worth the paper it is written on or that all that is needed is to rewrite ot without looking at or using the code, or some of the other suggestions here. Not hammering some guy for earning living.

OK so mark me down now for dissenting.

blocks|key|1392244|text|你付钱给他是为了服务而不是代码。事实上，他给你留下了他的代码的源代码，这不允许你使用它。即使这是他创造的单一字符，他也没有出售版权，他也没有授权你使用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392245|如果你想省钱，删除他的查询并从头开始编写你自己的查询，或者只是让他知道你正打算这样做，并提出以500美元的价格购买他的查询。他很可能会这么做，因为这将是他最后一次从你那里拿到钱的机会。|1392246|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You pay him for service not the code. The fact that he left you with source of his code does not allow you to use it. Even if that was single char he created it, he has not sold the copyright and he has not licensed you to use it.

If you want to save money delete his query and write your own from scratch or just let him know you are going to do just that and offer to buy his query for 500$. He'll probably go for it since it's going to be his last opportunity to get some of your money.

blocks|key|1176820|text|当校区雇用这个家伙的时候，它没有明确规定，他创建的所有东西都将属于学校，无论他在任何文件中写了什么？我要说的是，这比其他任何事情都重要。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176821|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

When the school district hired this guy, didn't it specify that everything he created would belong to the school, no matter what he wrote into any file? I'd say this takes precedence over anything else.

blocks|key|1176876|text|他可以在文件中写任何东西，但如果它是'wrok+for+hire‘，它就属于你。除非他有其他特定的合同，否则所有这些代码都是基于这个基础的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176877|在任何情况下，没有理由不自己重写它。如果你不使用他的代码，他怎么会抱怨呢？在任何情况下，真的没有法院会认真对待这一点，但从技术上讲，由于这两点，您也应该没有问题。更不用说他不能强迫你展示你有什么代码。|1176878|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

He can write anything in the file, but if it's 'wrok for hire' it belongs to you. All such code is on that basis unless he has some other specific contract.

In any event there's no reason not to rewrite it yourself. If you don't use his code how can he complain? Really no court would take this seriously in any event, but you should also technically be fine because of both those points. Not to mention he cannot force you to show what code you have.

blocks|key|1176927|text|这是不言而喻的，但我说的任何话都不应被视为法律建议。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176928|我会质疑最初把工作外包出去的人。如果合同没有正确签订，那么合同可能是作为恩惠授予的。这在政府工作中通常是不受欢迎的，而且这通常是一种糟糕的经营任何业务的方式(无论是否盈利)。|1176929|校方应认真审查其与该公司/个人的合同义务，因为该公司/个人可能欠一些钱。如果是在新墨西哥州，我认识一位专攻商法的律师。|1176930|你总是可以诉说这家伙富有同情心的一面：“为孩子着想”在我看来，每年500美元在某种艺术项目中至少会有一点用处。|1176931|希望事情会好起来！|1176932|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

It goes without saying, but nothing I say should be considered legal advice.

I would question the person who contracted out the work in the first place. If it was not properly contracted, then the contract may have been awarded as a favor. This is generally frowned upon in government work, and it is usually a poor way to run any business (for profit or not.)

The school authority should seriously review its contractual obligation with this company/individual, as he may owe some money. If this is in New Mexico, I know a lawyer who specializes in business law.

You could always appeal the this guy's compassionate side: "Think of the children" Seems to me $500 annually would go at least a little distance in an arts program of some sort.

Hope things work out for the best!

blocks|key|1392489|text|没有人会为了500美元的更改日期而起诉。如果我是程序员，我会更改日期，并且永远不会看back...and，如果我被叫回来更改日期，我会感到很尴尬。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392490|P|1392491|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Nobody is suing over a date change for $500. I'd change the date and never look back...and if I was the programmer I'd be embarrassed to be called back to change the date.

P

blocks|key|1392556|text|似乎没有人注意到版权与复制有关的事实。如果OP既不是复制也不是分发，那么版权似乎真的不适用于这种情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392557|即，未经许可，学校不得将其作品作为自己的作品出版或出售。在这些案件中你应该咨询你的律师。|1392558|在任何情况下，OP都同意运行在特定文件中运行某些sql的程序。我假设OP没有绕过程序员设置的任何防篡改控制。|1392559|sql是程序的一部分(尽管是受雇工作)，它只是文件中的文本。现在可能的情况是，在未经程序员明确同意的情况下修改与程序相关的任何/所有文件可能会使任何担保无效，但仅此而已。|1392560|只要500美元，没人会起诉你。你知道律师费是多少吗？但是，如果您取消了原始程序员的任何支持，也不要感到惊讶。这是个合理的警告。|1392561|总而言之，如果这个人为了500美元所做的一切都是为了2分钟的零钱，这有点轻率。但你确定这就是他所做的一切吗?以正常的咨询费收费，一天半的工作500美元并不是不切实际的。|1392562|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Nobody seems to have picked up the fact that Copyright deals with copying. If the OP is neither copying nor distributing, Copyright really doesn't appear to apply in this instance. 

i.e. the School may not publish or sell as their own work (perhaps) without permission. You'd want to consult your lawyer in those cases.

In any event, the OP has consent to run the program which runs some sql in a particular file. I assume the OP hasn't circumvented any anti-tampering controls put in place by the programmer.

The sql, which is part of the program (work for hire notwithstanding), is just text in a file. Now it may be the case that modifying any/all files related to the program without express consent of the programmer may void any warranties, but that's really about it.

And for $500, nobody's going to sue you. Do you know what lawyers cost? But don't be surprised if you void any support by the original programmer. Fair warning there. 

When all is said and done, if all the guy does for $500 is take a 2 minute change that's a bit brash. But are you certain that's all he's doing? $500 for a 1/2 days work at a normal consulting charge out rate isn't unrealistic.

blocks|key|1392640|text|使用原始查询作为基础定义一个新视图，而不指定日期参数，例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392641|create+or+replace+view+MY_VIEW+as
+select+STUDENT_NAME,+STUDENT_NO,+CLASS_YEAR
+++from+STUDENT_TABLE
++where+STUDENT_CLASS+=+10|code-block|syntax|javascript|1392642|编写一个新的查询，以应用日期参数从视图中进行选择，例如|1392643|set+DATE_PARM+=+'2009';
select+STUDENT_NAME,+STUDENT_NO,+CLASS_YEAR
++from+MY_VIEW
+where+CLASS_YEAR+=+%25DATE_PARM|1392644|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Define a new view using the original query as a base without specifying the date parameter e.g. 

<pre><code>create or replace view MY_VIEW as
 select STUDENT_NAME, STUDENT_NO, CLASS_YEAR
 from STUDENT_TABLE
 where STUDENT_CLASS = 10
</code></pre>

Write a new query to select from the view applying the date parameter e.g.

<pre><code>set DATE_PARM = '2009';
select STUDENT_NAME, STUDENT_NO, CLASS_YEAR
 from MY_VIEW
 where CLASS_YEAR = %DATE_PARM
</code></pre>

blocks|key|1177202|text|学校和承包商之间的合同条款是什么？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177203|(我没有太多的hope...but，我知道我为我的雇主写的任何东西都与拥有版权的他们签订了合同)|1177204|我希望你在这个关于蛇油小贩的问题上发表的愤怒的帖子能让你放心(我知道我是)。|1177205|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

What were the terms of the contract between the school and the contractor? 

(I don't hold out much hope...but I know that anything I write for my employer is contractually bound to them owning the copyright)

I hope you find it reassuring the amount of outraged posts you have had on this question about this snake oil pedlar (I know I do)

blocks|key|1392720|text|如果您发布查询的全文，我们可能会提供帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392721|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you post the full text of the query, we might be able to help.

blocks|key|1177280|text|提议让他更新查询，以处理$500的参数，并在合同中包含“雇佣工作”条款。如果他不接受，就重写。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177281|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Offer to have him update the query to handle parameters for $500 and include a "work for hire" clause in the contract. If he doesn't accept, rewrite it.

blocks|key|1392823|text|为什么不直接打电话问他发生了什么事？这可能是他代码中的样板注释，他可能一点也不在意。如果他真的在乎，可能更多的是发布他的代码，而不是使用它。此外，如果他担心500美元以上，那么他也没有足够的钱聘请律师。最后，他必须证明您使用了他的代码-他将如何做到这一点？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392824|@PurplePilot+PurplePilot提出了很好的观点。如果我已经有一年没有收到客户的消息了，我可能要花30分钟才能调出我的旧笔记、密码等，并重新回忆一下发生了什么。然后，假设单击按钮仍然有效，我可能至少想要做一些抽查。然后你必须把它发送给那个人(谁知道今年是不是同一个人--你可能不得不向他们解释如何处理这个文件)。然后，如果您计划获得付款，则必须生成发票。|1392825|基本上，如果你以咨询为生，一天8小时是拿不到报酬的。但是，如果有人一年给你打一次电话，光是行政事务就得花一两个小时。|1392826|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Why not just call the guy and ask him what's up? It's probably boiler-plate comments in his code and he probably doesn't give a toss. If he does care at all, it's probably more to do with releasing his code rather than using it. Also, if he's that concerned over $500, then he doesn't have enough money to hire a lawyer anyway. Lastly he would have to prove that you used his code - how's he going to do that?

@PurplePilot PurplePilot makes a good point. If I haven't heard from a client in a year, chances are it'll take me 30 minutes just to pull up my old notes, passwords, etc and refresh my memory as far as what is going on. Then, assuming the single-click button still worked, I would probably at least want to do some spot checking. Then you have to send it off to the person (who knows if it is even the same person this year - you might have to explain to them what to do with the file). Then you have to generate an invoice if you plan on getting paid.

Basically if you consult for a living you don't get paid for 8 hours a day. But when somebody calls you once a year, it takes an hour or two just for administrative stuff.

blocks|key|1177371|text|另一种选择(您可能会或可能不会实现，风险自负--咨询律师！)：让他的代码保持原样。编写一个包装器，在运行它之前读取他的SQL并执行s/2009/$this_year/。好了，你什么都没改变...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177372|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Another option (which you may or may not implement AT YOUR OWN RISK -- CONSULT A LAWYER!): Leave his code as is. Write a wrapper that reads his SQL and does a s/2009/$this_year/ before running it. There, you haven't changed anything...

blocks|key|1177411|text|所以这是我对法律方面的看法……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177412|您需要在第一次交付该软件时查看合同情况，并确定谁是知识产权的所有者(如果我误解了“受雇”一词，很抱歉：|1177413|1)此人是根据临时或无限制雇佣合同被贵公司聘用的。雇佣合同通常包含一个条款，声明这个人在雇佣期间创造的所有知识产权仍然是你公司的财产-很好的例子|1177414|2)你从他的公司购买了一次性的定制服务。知识产权是你的--很好的案例|1177415|3)你购买了一件软件的使用权，它仍然是他的知识产权，你无权更改代码-糟糕的情况|1177416|要确定2..3中的哪一个适用，请查看他发送的发票以及您或他强加的任何条款和条件。|1177417|另一个问题是，合同情况是否仍然在进行，即这个人是否有责任在一段时间内维护代码，或者确保代码正常工作，或者他必须满足代码上的任何SLA。在这种情况下，他声称的费用是正确的(我不想在这里评论价格价值)。|1177418|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

So here's my view on the legal side of things ....

You need to look into the contractual situation at the first time delivery of that piece of software and determine who is the owner of the intellectual property (and sorry if I misinterpret the term "employed":

1)
this guy was employed by your company according to a temporary or unlimited employment contract. Employment contracts usually contains a clause stating that all intellectual property this guy creates during employment remains the property of your company - GOOD CASE

2)
you bought a one-off bespoke service from his company. The intellectual property is yours - GOOD CASE

3) 
you bought the usage right on a piece of software, it remains his intellectual property and you are not entitled to change the code - BAD CASE

To determine which of 2..3 applies, look up the invoice he sent plus any terms and conditions either you or he imposed.

Another question is, whether the contractual situation still is ongoing, i.e. is this guy liable to maintain the code over time or to make sure it's working or does he have to fulfill any SLA on that code. In this case the fee he claims is rectified (and I don't want to comment on price-worthiness here).

blocks|key|1392942|text|SQL查询绝对可以受版权保护。然而，版权法只有在您分发源代码(即制作副本)的情况下才有意义。如果顾问提供了源代码的副本，而您没有将其传递给其他人，则不适用版权法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392943|你和这位顾问之间的协议完全是另一回事。检查合同是否授予您永久使用代码的许可。或者，在明年聘用他之前，请他修改协议(以及源代码注释)。如果有疑问，请咨询真正的律师。|1392944|免责声明:我不是律师。|1392945|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

SQL queries absolutely can fall under copyright. However, copyright law is relevant only if you were to distribute the source code (i.e. make copies). Given that the consultant furnished a copy of the source code and you do not transmit it to others, copyright law does not apply.

The agreement between you and this consultant is another matter entirely. Check whether the contract granted you a license to use the code in perpetuity. Alternatively, ask him to revise the agreement (and the source code comments) before you hire him next year. When in doubt, check with an actual lawyer.

Disclaimer: I'm not a lawyer.

blocks|key|1392978|text|如果编写它的开发人员对他的产品有信心，他可能会在没有这样的限制的情况下发布它，并使他的工作受到同行的审查。二流的开发人员可能会高估他的作品，并像这样写版权声明。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1392979|他说你可以获得书面许可。你为什么不写信给他，告诉他你正在修改他的代码，而不是问他呢？证明你的行为是合理的，看看他是否会挑战你。|1392980|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If the developer who wrote it was confident in his product, he might release it without such restrictions and subject his work to the scrutiny of his peers. A second rate developer might over value his work and write copyright notices like that. 

He states you may obtain written permission. Why don't you write him and tell him you're modifying his code rather than ask? Justify your actions and see if he challenges you.

blocks|key|1393029|text|首先，停止这种免责声明的胡言乱语。即使你说“我是个律师，真的”，你也不是律师。我知道是因为我是尼日利亚国王的儿子。任何从论坛接受法律建议的人都是注定要失败的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393030|1)代码受版权保护。如果没有合同/协议另有说明，则版权属于制作代码的人。|1393031|2)每年改变年份变量收取500美元的费用是离谱的，但并不是不道德的。这就是资本主义的运作方式。然而，修改代码直到使其所有者的权利失效肯定是不道德的。|1393032|你需要做的就是雇佣一个人(或者同一个人，谁是最便宜的)，来写一个每年都能工作的查询。这是每年摆脱500美元的正确和合乎道德的方式。这次别忘了把你的条款设置好(谁拥有版权等)。|1393033|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

First, stop this disclaimer nonsense. You're not a lawyer even when you say "I'm a lawyer, seriously" anyway. I know this because I'm son of the king of Nigeria. Anyone who takes legal advice from a forum is doomed.

1) The code is copyrighted. If there are no contracts/agreements stating the otherwise, copyright belongs to the person who produced the code.

2) Charging $500 every year for changing year variable is outrageous but not unethical. That's how capitalism works. However modifying a code till you invalidate its owner's rights is certainly unethical. 

What you need to do is to hire someone (or the same guy, whoever's cheapest), to write a query that works every year. That's the RIGHT and ETHICAL way of getting away from $500 every year. Don't forget to set your terms right this time (who owns copyright etc).

blocks|key|1177601|text|威胁要“指名道姓”，除非他给你书面许可，让你按你认为合适的方式修改文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177602|像这样做不道德事情的底层开发者会给自由软件开发人员带来坏名声。他不配得到工作..。国际海事组织。|1177603|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Threaten to "name and shame" him unless he gives you written permission to modify the file as you see fit.

Bottom feeders who do unethical things like that give freelance software developers a bad name. He doesn't deserve to get work ... IMO.

blocks|key|1393159|text|我不知道为什么你们中的大多数人如此专注于他编写的代码，而不是他编写代码的条件。最初的合同，假设有一个，应该在合同的末尾写出谁拥有代码。学校继续雇佣他，并付钱给他，让他重写他的“原始”代码，因此必须有他的聘用条款。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393160|顺便说一句，学校雇佣了一个人来写代码，并且规定他们永远不能拥有他为他们写的代码，这是愚蠢的。|1393161|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I'm not sure why most of you are so hung up on the code that he wrote and not hung up on the conditions under which he wrote the code. The original contract, assuming there was one, should spell out who owns the code at the end of the contract. The school has continued to hire and pay him to rewrite his "original" code and therefore there must be terms of his hire.

On a side note, it's just silly for the school to have hired someone to write code with the stipulation that they never own the code that he's been writing for them.

blocks|key|1177677|text|添加:和其中的1=1。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177678|新的查询，问题解决了。|1177679|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

ADD: AND WHERE 1=1.

New query, problem solved.

blocks|key|1393232|text|既然我们都不是这里的律师，我想指出一下这篇文章是很有趣的，因为这篇文章在Techdirt上确实有相当多的合法追随者，特别是在版权领域。想知道他们有什么要说的吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393233|Can+You+Copyright+An+SQL+Query?|offset|length|1393234|entityMap|0|LINK|mutability|MUTABLE|url|http://techdirt.com/blog/itinnovation/articles/20091204/0027017199.shtml^0|0|0|V|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Since we are all NOT lawyers here, I thought it would be interesting to point out that this post made its way to Techdirt which does have quite a large legal following, especially in the copyright field. Curious to see what they have to say about it?

<a href="http://techdirt.com/blog/itinnovation/articles/20091204/0027017199.shtml" rel="nofollow noreferrer">Can You Copyright An SQL Query?</a>

blocks|key|1393304|text|我会仔细研究所有的协议。你永远不会知道，他可能只在第一年支付了500美元，因为他知道他将支付某种形式的年费。这为学校系统节省了一大笔钱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393305|如果你的应用程序的数据结构发生了变化呢？他可能不得不花几天时间重写查询，结果只得到了500美元。|1393306|也许学校系统不想年复一年地收取无限制的小时费，而只是决定500美元是固定的费用。|1393307|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I would dig through all of the agreements. You never know, he may have only been paid $500 the first year with the understanding he would be under some type of annual fee. This saved the school system a lot of money up front. 

What if the data structure of your applicaton changes? He may have to put days into rewriting the query and only get $500.

Maybe the school system didn't want some open-ended hourly fee year after year and just decided that $500 was a flat fee.

blocks|key|1177867|text|真是一派胡言。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177868|我的建议是更改SQL，运行查询，然后等待对方采取法律行动。选择法庭听证，并将结果直播到这个帖子上。听起来很有趣，一方面是一个剥削性的承包商，另一方面是一个胆小得不能让你继续做生意的经理。我很感兴趣的是，承包商如何改变计划，然后传唤你的代码库，以确定你是如何在没有他的情况下完成年终工作的。|1177869|因为(C)当然是全能的，你不知道吗。你不能说它不是，因为我把一个C括起来，我是这么说的。|1177870|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

What a remarkable load of bollocks.

My advice is to change the SQL, run the query, and wait for the guy to take legal action. Opt for a court hearing and live-blog the results to this thread. Sounds like it would be entertaining, on the one side an exploitive contractor and on the other a milquetoast manager too timid to let you just get on with business. I'm interested to see how the contractor twigs to the scheme and then subpoenas your codebase to determine how you managed to do a year-end without him. 

Because of course, (C) is all-powerful don't you know. And you're not allowed to say it isn't because I bracketed a C and I say so.

blocks|key|1177954|text|我是一名DBA，使用大量带有固定SQL代码的第三方应用程序，我从来没有见过这样的东西附加到SQL语句中。如果你可以直接访问数据库，并且可以从数据库中查询数据，那么只需重写代码，不要再花他一秒钟的时间，因为500美元的单个过程看起来就像从一开始就像撕裂一样。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177955|但如果不看代码，就不知道它涉及的程度有多大。我已经编写了一些SQL语句，它们需要数百行代码来获取数据，它们可能需要几天甚至几周的时间来编写和调试。如果这家伙在这个过程中投入了那么多时间，而你每次跑一次都要花500美元，这可能是值得的……但是，如果它只是一个不超过12行左右的简单向前Select语句，那么它就不值500美元，可以由您或其他对SQL有基本了解的人来编写。即使它看起来和他的很相似，老实说，有时候写东西的方法也只有这么多。“狗是蓝色的”...你可以用多少种方式来表达？不是很多:)|1177956|是的，我也不是律师，但当遇到这种事情时，我的道德准则指导着我。|1177957|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I'm a DBA and work with lots of third party applications with canned SQL code, and I've never seen something like this affixed to a SQL statement. If you have direct access into the database and can query data from it, just rewrite the code and don't give the guy another second's time as $500 for a single process like this seems like a rip from the get go.

But without seeing the code there's no telling how involved it is. I've written some SQL statements that go into hundreds of lines to get data, and they can take DAYS or even WEEKS to write and debug. If this guy invested that kind of time into the process and you're paying $500 per run, it may be worth it ... but if it's just a strait forward Select statement that's no more then a dozen or so lines long, that is not worth $500 and can be written by you or someone else with a basic understanding of SQL. Even if it looks similar to his, honestly sometimes there's only so many ways to write something. "The dog is blue"... how many ways can you say it? Not many :)

Yeah, I'm no lawyer either, but when it comes to things like this my ethics are what guide me.

blocks|key|1178032|text|公布那个人的名字，这样我们都知道他是个工具。不用说，这不是法律建议，但如果你签了合同，他所做的任何事情都可能是“受雇工作”，因此归你所有。我认为他甚至不太可能尝试采取法律行动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178033|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Post the guy's name so we all know that he is a tool. Needless to say this is not legal advice but if you contracted the guy anything he's done might be "work for hire" and thus is owned by you. I would find it very unlikely that he will even attempt to start legal action.

blocks|key|1178110|text|更改参数需要500美元？！如果你熟悉一个SQL，你应该重新实现它，或者如果你不熟悉SQL，你应该再次雇用这个人，并让他制作文档。之后，您可以使用ETL工具并自己构建导出。你可能想试试SSIS。这就是它的完美用例。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1178111|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Extract,_transform,_load|1|http://en.wikipedia.org/wiki/SQL_Server_Integration_Services^0|20|3|0|2J|4|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

$ 500 for a parameter change?!
If you are familiar with a SQL you should reimplement it or if you are not familiar with SQL you should hire the guy once more and ask him to make a documentation. After it you can use an <a href="http://en.wikipedia.org/wiki/Extract,_transform,_load" rel="nofollow noreferrer">ETL</a> tool and build the export yourself. You might want to try <a href="http://en.wikipedia.org/wiki/SQL_Server_Integration_Services" rel="nofollow noreferrer">SSIS</a>. It's the perfect use case for it.

blocks|key|1178156|text|相反，您应该考虑学习该查询的重要方面，并实现您自己的版本，您也可以获得版权。如果你不能做到这一点，你最好买一个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178157|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You should instead consider learning the important aspects of that query and implement your own version which you can copyright too. If you can't do so, you are better off buying one.

blocks|key|1178213|text|检查一下你和那家伙的公司的合同。它可能已经说你拥有他们写的任何代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178214|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check your contract with the guy's company. It may already say that you own whatever code they've written anyway.

blocks|key|1393813|text|只要解释你的表和字段的结构和问题，如果只是查询的问题，这里的许多人足够聪明和慷慨，可以免费做这件事……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393814|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

just explain your table and field structure and problem , if it is just matter of query , many of people here are smart and generous enough to do it for free...

blocks|key|1393864|text|已经有很多答案了，但我只是想补充一下我的经验:当你谈论的价格低于100万美元时，版权根本不重要。他会怎么做，提起版权诉讼吗？你觉得那要花多少钱？他怎么能证明你侵权了呢？哪个陪审团会投票反对一个学区？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393865|你应该问自己的真正问题是:我们愿意和这个年薪500美元的人做朋友吗？如果你对他的问题感到满意，那么一年500美元真的不是一个糟糕的交易。|1393866|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

A lot of answers already, but just to add my experience: copyright does not matter at all when you're talking less than $1,000,000. What is he going to do, file a copyright suit? What do you think that would cost? How is he going to prove you infringed? Which jury is going to vote against a school district?

The real question you should ask yourself is: would we like to be friends with this guy for $500 dollar a year? If you're happy with his query, $500 a year is really not such a bad deal.

blocks|key|1393913|text|我记得我读过一本关于谈判的书。作者描绘了这样一个场景:一群人每年租用一个大厅开会。协调人发出邀请，大厅的主人决定过高地提高房租。作者建议你向大厅的老板解释，他们可以A:按他们的要求提高租金，并失去未来的业务；或者B:将租金降低到合理的水平，并保留他们的业务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1393914|程序员认为他们对你的公司有一些牵制，在某种程度上他/她有理由这样做。你的公司一直在付钱给他/她。说明程序员可以“免费”使用参数化查询来解决问题，否则就会永远失去公司的业务。你的公司有一些筹码，利用它。|1393915|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I remember reading a book on negotiation. The author paints a scenario where a group rents a hall annually for their meeting. The coordinator sends invitations and the owners of the hall decide to raise the rent exorbitantly. The author suggests that you explain to the owner of the hall that they can A: raise the rent as they ask and lose future business OR B: bring the rent back down to a reasonable rate and keep their business.

The programmer thinks they have some leash on your company and to some degree he/she has reason to. Your company has been paying him/her. Explain that the programmer can fix the problem with a parameterized query 'for free' or eternally lose your company's business. Your company has some leverage, use it.

blocks|key|1178452|text|这不是版权的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178453|而是他被雇来做什么。|1178454|如果他受雇生产SQL代码，而合同规定您是代码的所有者-那么代码就是您的。|1178455|另一方面，如果他是被付钱提供服务的，那么可以说SQL代码是他的。|1178456|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

This is not a case of copyright.

But what he was hired to do in the first place.

If he was hired to produce SQL code and the contract states you are the owners code - then the code is yours.

If on the other hand he was paid to supply a service, then it can be argued that the SQL code is his.

blocks|key|1178493|text|正如其他人在这里所说的“我不是律师”，但我确实处理了相当多的知识产权。版权不能用来保护一个想法。它是用来保护表达式的。换句话说，如果有人写了一篇文章或一本书或画了一幅画，没有版权所有者的明确许可，你不能复制受版权保护的作品。如果您将查询的文本剪切并粘贴到您自己的文本中，则很可能侵犯了版权。另一方面，如果你写自己的查询，得到相同的结果，但以不同的方式，你将不会侵犯版权。我认为你必须问自己的问题是“我能不能在不复制/粘贴原始查询的情况下编写一个类似的查询？”|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178494|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Just as others have stated here "I am not a lawyer" but I do deal quite a bit with intelectual property.
Copyright can not be used to protect an idea. It is meant to protect an expresion. In other words, if someone was to write an article or a book or paint a picture you can't reproduce the copyrighted works without an express permission of the copyright holder.
If you were to cut and paste the text of the query in to your own, you would most likely be violating the copyright. On the other hand, if you were to write your own query that achieves the same results but in a different way you would nto be infringing on the copyright.
I think the question you have to ask yourself "can I write a similar query without copy/paste of the original query?"

blocks|key|1394096|text|任何内容都可以被复制，包括SQL，这些方法可以被视为商业秘密。SQL+procs可以是整个应用程序的一个组件，除非它们以免费软件、开源软件或GPL的形式向公众发布。如果您对侵犯您提到的SQL+proc感到不安，您所要做的就是使用替代语句稍微修改SQL+proc，或者向其添加一个不会影响预期结果的虚拟部分。例如，在化工产品行业:+ECOLAB生产的一种清洁产品，其活性和非活性化学成分的混合物获得了专利，已被其他几个竞争对手模仿，这些竞争对手以低得多的价格销售基本上相同的产品。规避侵犯ECOLAB专利的方法是将一个或多个化学梯度的含量修改1%25。因此，以此作为类比，您可以对复制的SQL过程执行相同的操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1394097|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

any content can be copywrited, including SQL procs, which methods may be considered a trade-secret. SQL procs can be a component of an entire application which most all are copywrited, unless the are released to the public as freeware, open source or with a GPL. If you feel uneasy about infringing on the SQL proc you mentioned, all you have to do is slightly modify the SQL proc by using an alternative statement or add a dummy part to it which has no effect on the desired result. In the chemical products industry, for example: a cleaning product made by ECOLAB, whose mixture of active and inactive chemical ingridients is patented, has been imitated by several other competitors who sell basically the same product for much less. The way the got around infringing on ECOLAB's patent is to modify the content of one or more chemical ingridients by 1%. So, using this as an analogy, you can do the same to the copywrited SQL proc.

blocks|key|1178592|text|**一切**都可以拥有版权。如果你觉得你可以自己完成这项工作，那就继续，并结束与程序员的安排。我建议您尝试自己编写查询(因为它既有趣又有教育意义)，而不是复制/粘贴现有的查询(因为这通常会导致糟糕的结果)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178593|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

** EVERYTHING** can be copyrighted. If you feel that you can do the job yourself, go ahead and end the arrangement with the programmer. I would suggest that you attempt to write the query yourself (as it is both fun and educational) and not copy/paste the existing one (as this usually ends badly).

I work for a school district. Every year we have to export a list of students from our student management system and send it to a company that handles our online exams.

So to do this export, we had to hire someone who knew the inner workings of our student management system. He wrote an sql (Adaptive Sybase SQL Anywhere) query to export the students to a csv file like we needed. This was before I started working for the district, so for a while I assumed this was an actually application, until it came time for me to do the export myself.

And every year he charges us $500 to update this query to export the students for the current year. So when I discovered it was only a query (.bat file and .sql file), my thought was "I can update this myself". All I have to do is change the years in the query (eg. 2009 to 2010).

The query (.sql file) itself has this comment at the top:

<pre><code>// This code was writtend by [the guy]
// and is the property of [his company]...Copyright 2005,2006,2008,2009
// This code MAY NOT BE USED without the expressed written consent of 
// [his company].
</code></pre>

(Yes, it really does says "writtend".)

So now my boss is worried that we're violating the copyright. And that the guy is gonna find out that I updated the query myself because we haven't asked him to update it this year and take legal action.

So back to the subject's question:
Can he really copyright this query?
And if so, is modifying it ourselves a copyright violation?
In my mind, a single query isn't program code. It's more a command line command. But I don't know what it's considered legally.

Can someone copyright a SQL query?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在一个学区工作。每年，我们都必须从学生管理系统中导出一份学生名单，并将其发送到一家处理我们在线考试的公司。因此，为了实现出口，我们必须聘请了解我们学生管理系统内部工作原理的人。他编写了一个sql (Adaptive Sybase SQL Anywhere)查询，根据我们的需要将学生导出到csv文件。这是在我开始为该地...

问有人可以对SQL查询进行版权保护吗？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有人可以对SQL查询进行版权保护吗？EN