我该如何编写查询 [英] How do I write the queries
问题描述
编写一个SP，其中部门编号作为参数，百分比作为另一个参数，计数作为输出参数，按指定的百分比增加项目预算（由部门控制），并找出为项目工作的唯一员工数量由部门控制。
写一个SP，项目编号作为参数，列出（选择）控制项目的部门，并列出（选择）其他项目控制由同一部门组成。
写一个SP，给定项目编号作为参数，返回该项目唯一职称的编号作为输出参数，以及其他项目中项目工作者的唯一作业标题的数量作为另一个输出参数。
write a SP with department number as parameter, a percentage as another parameter, and a count as an output parameter, increase budgets of projects (controlled by the department) by the specified percentage and find out number of unique employees working for projects controlled by the department.
write a SP with a project number as parameter, list(select) the department that controls the project, and list (select) other projects controlled by the same department.
write a SP, given a project number as parameter, return the number of unique job title of this project as an output parameter, and the number of unique job title of the project's workers in other projects as another output parameter.
推荐答案
而不是等待某人为你不太可能发生这种情况，请阅读这篇文章：
1. Sql Server - 如何在Sql server中编写存储过程 [ ^ ]
2. SQL教程 [ ^ ]
使用它们作为自己解决功课的参考。
开始破解......
Instead of waiting for someone to do it for you which is unlikely to happen, read this articles:
1. Sql Server - How to write a Stored procedure in Sql server[^]
2. SQL Tutorial[^]
Use them as references to solving your homework by yourself.
Start cracking...
这篇关于我该如何编写查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
