can we use packages in ms sql server 2008...i m new to sql server ... if yes how it can be created and used....
我们可以在ms sql server 2008中使用软件包...我是sql server的新手...如果是的话它是如何创建和使用的....
2 个解决方案
#1
The only thing somewhat similar would be a SQL-CLR assembly, e.g. C# code compiled into an assembly, hosted inside SQL.
唯一有点相似的是SQL-CLR程序集,例如C#代码编译成一个程序集,托管在SQL中。
There's no equivalent of a package for T-SQL stored functions and stored procedures in SQL Server.
SQL Server中的T-SQL存储函数和存储过程没有相应的包。
What do you need that for, anyway? Granting permissions?
无论如何,你需要什么呢?授予权限?
What you could investigate, too, are the schemas in SQL Server, which also help you grant or manage permissions - but it's quite a different beast from Oracle PL/SQL packages. Schemas manage collections of database objects (any of them - tables, views, stored procs and funcs).
你可以调查的是SQL Server中的模式,它也可以帮助你授予或管理权限 - 但它与Oracle PL / SQL包完全不同。模式管理数据库对象的集合(其中任何一个 - 表,视图,存储过程和函数)。
- Working with schemas in SQL Server 2005
- Security enhancements in SQL Server 2005 - schemas
在SQL Server 2005中使用模式
SQL Server 2005中的安全性增强 - 模式
Marc
#2
I assume you are talking about the Oracle concept of a package which groups related queries etc. If so as far as I know this concept doesn't exit in SQL Server. Also you will get some interference when trying to Google for this from DTS packages, which are a completely different concept.
我假设您正在讨论将包相关查询等分组的Oracle概念。如果是这样的话,据我所知这个概念不会在SQL Server中退出。当你从DTS包中尝试谷歌时,你会受到一些干扰,这是一个完全不同的概念。
#1
The only thing somewhat similar would be a SQL-CLR assembly, e.g. C# code compiled into an assembly, hosted inside SQL.
唯一有点相似的是SQL-CLR程序集,例如C#代码编译成一个程序集,托管在SQL中。
There's no equivalent of a package for T-SQL stored functions and stored procedures in SQL Server.
SQL Server中的T-SQL存储函数和存储过程没有相应的包。
What do you need that for, anyway? Granting permissions?
无论如何,你需要什么呢?授予权限?
What you could investigate, too, are the schemas in SQL Server, which also help you grant or manage permissions - but it's quite a different beast from Oracle PL/SQL packages. Schemas manage collections of database objects (any of them - tables, views, stored procs and funcs).
你可以调查的是SQL Server中的模式,它也可以帮助你授予或管理权限 - 但它与Oracle PL / SQL包完全不同。模式管理数据库对象的集合(其中任何一个 - 表,视图,存储过程和函数)。
- Working with schemas in SQL Server 2005
- Security enhancements in SQL Server 2005 - schemas
在SQL Server 2005中使用模式
SQL Server 2005中的安全性增强 - 模式
Marc
#2
I assume you are talking about the Oracle concept of a package which groups related queries etc. If so as far as I know this concept doesn't exit in SQL Server. Also you will get some interference when trying to Google for this from DTS packages, which are a completely different concept.
我假设您正在讨论将包相关查询等分组的Oracle概念。如果是这样的话,据我所知这个概念不会在SQL Server中退出。当你从DTS包中尝试谷歌时,你会受到一些干扰,这是一个完全不同的概念。