找到你要的答案

Q:Stored Procedure libraries

Q:存储程序库

Let's say I have a Data Access class library containing thousands of methods, with each one calling a stored procedure in a SQL Server database. The methods are organized in about a hundred separate classes. Is there a way to create collapsible libraries or something to that effect instead of having one gigantic listing of stored procedures?

比方说,我有一个数据访问类库包含成千上万的方法,每一个SQL Server数据库中调用存储过程。该方法是组织在大约一百个单独的类。有没有办法创建可折叠的库或某种效果,而不是有一个巨大的存储过程列表?

answer1: 回答1:

Assuming that you're asking about the list of procedures that appears in the UI of SQL Server Management Studio, I don't think there's a way to do that by default. One workaround that you might consider would be to group your stored procedures into different schemas, perhaps matching your classes in your data access layer, and then use the filtering in SSMS to only show the schema that you're interested in seeing at that time.

假设你询问程序出现在SQL Server Management Studio用户界面的列表,我不认为有办法做,默认。一个解决办法,你可以考虑将你的存储过程分成不同组模式,也许匹配你的课对你的数据访问层,然后用过滤的安全措施,只显示模式,你看到当时感兴趣。

sql-server  stored-procedures