摘要:
1 SELECT SYS.DM_EXEC_REQUESTS.SESSION_ID,TEXT AS '执行SQL',CLIENT_NET_ADDRESS AS '请求IP',SYS.DM_EXEC_CONNECTIONS.CONNECTION_ID AS '连接ID',LAST_READ AS '最后读取时间',LAST_WRITE AS '最后写入时间',CLIENT_TCP_PORT AS ... 阅读全文
摘要:
A库 CREATE PROCEDURE [dbo].[A_P_Test] AS BEGIN SELECT * FROM dbo.A_LoadData END B库 在B中调用A库存储过程 注:是同一服务器调用。 CREATE PROCEDURE [dbo].[A_P_Test2] AS BEGIN 阅读全文