sqlserver主要的环境变量

最新推荐文章于 2024-08-10 16:59:26 发布

xien126

最新推荐文章于 2024-08-10 16:59:26 发布

阅读量3.3k

点赞数

文章标签： sqlserver table function object insert permissions

本文链接：https://blog.csdn.net/xien126/article/details/357110

版权

该存储过程`usp_AllOperation`展示了SQL Server的主要环境变量，包括`@@REMSERVER`, `@@SERVICENAME`, `@@SPID`等，并进行相关设置。此外，它还查询了系统状态，如`sp_who`、`sp_monitor`，以及表、函数、对象的相关属性，例如`OBJECTPROPERTY`。最后，存储过程展示了如何使用`OPENXML`和`PARSENAME`函数处理XML数据。" 112584512,10548381,PostGIS教程：检测与修复几何图形无效性,"['GIS', '数据库', 'PostGIS', '空间分析']

摘要由CSDN通过智能技术生成

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE PROCEDURE usp_AllOperation AS /* ======================================================== Procedure: usp_AllOperation Description: 系统主要的环境变量以及设置 Creation Date: 2005-4-21 Author: 谢恩 ======================================================== Revision History ======================================================== Rev Date Description ======================================================== 1 2005-4-21 Generated by 谢恩 ======================================================== */ BEGIN SELECT @@REMSERVER SELECT @@SERVICENAME SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name' EXEC master.dbo.sp_who 'sa' SELECT @@TEXTSIZE SET TEXTSIZE 2048 SELECT @@TEXTSIZE SELECT @@TIMETICKS exec master.dbo.sp_monitor SELECT @@IDLE AS 'IDLE', @@IO_BUSY AS 'IO_BUSY', @@CPU_BUSY AS 'CPU_BUSY', @@CONNECTIONS AS 'CONNECTIONS', @@TOTAL_READ AS 'TOTAL_READ', @@TOTAL_WRITE AS 'TOTAL_WRITE', @@TOTAL_ERRORS AS 'TOTAL_ERRORS', GETDATE() AS 'As of&#