一些SQLServer存储过程参数及举例
86 浏览量
2020-12-15
10:34:17
上传
评论
收藏 50KB PDF 举报
一些一些SQLServer存储过程参数及举例存储过程参数及举例
Microsoft included several hundred stored procedures in the various versions of Microsoft SQL Server and it has
documented a good percentage of them. But many stored procedures remain undocumented. Some are used within the
Enterprise Manager GUI in SQL 2000 and were not intended to be used by other processes. Microsoft has slated some of
these stored procedures to be removed (or they have been removed) from future versions of SQL Server. While these
stored procedures can be very useful and save you lots of time, they can be changed at any time in their function or they can
simply be removed.
The chart below shows that while many of the procedures have been carried through from one version of Microsoft SQL
Server to another, new stored procedures have been introduced, and some have been removed from the install package.
Most, if not all, of the procedures require the user to be a member of the sysadmin fixed server role in order to execute the
procedures. The stored procedures that interact with the file system also require that the user executing the procedure (as
well as SQL Server’s service account) have access to the file/folder.
评论0
最新资源