由于SQL Server没有软件包，程序员应采取哪些措施解决它? [英] Since SQL Server doesn't have packages, what do programmers do to get around it?

问题描述

我有一个SQL Server数据库，该数据库具有大量存储过程.由于Oracle的打包"功能，大量的存储过程在我的Oracle数据库中不是问题.

I have a SQL Server database that has a huge proliferation of stored procedures. Large numbers of stored procedures are not a problem in my Oracle databases because of the Oracle "package" feature.

程序员应该采取什么措施来解决缺少像Oracle这样的软件包"功能的问题?

What do programmers do to get around the lack of a "package" feature like that of Oracle?

推荐答案

虽然SQL Server无法像以前那样通过封装和包状态的炫酷功能"提供任何强大功能，您可以将存储过程组织到架构中.

While SQL Server has nothing to offer by way of the "cool features" of encapsulation and package state like you are used to, you can organize your stored procedures into schemas.

在企业管理器中，这些proc仍被一起列出，如果您有数百个proc，它们将成为一个巨大的树形列表.我也想念Oracle软件包的组织和出色功能.但是，所有平台都有其优势.

In enterprise manager, these procs are still all listed together which makes for a HUGE treelist if you have hundreds of procs. I too miss the organization and cool features of Oracle packages. However, all platforms have their strengths.

注意:用.NET语言编写存储过程确实可以实现封装和状态.但是，它仍然没有以任何特殊方式在EM树视图中将它们分开.

NOTE: Writing stored procedures in the .NET language DOES give you encapsulation and state. It still does not however separate them in the EM treeview in any special way.

这篇关于由于SQL Server没有软件包，程序员应采取哪些措施解决它?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！