FlameXu的专栏

--1.查找运行时间超过9小时的当前Win.exe程序的非活动Sessionselect SID,Serial#, SQL_ID,MACHINE,terminal,SECONDS_IN_WAIT,client_info,status,program,module,round(SECONDS_IN_WAIT/3600) as waithour from v$sessionwhere stat

//数据字段值转化function VarToSql(value: variant): string;begin  if VarIsNull(value) then    Result := 'NULL'  else    case VarType(value) of      vardate:        Result := Quotedstr(Dateti

USE [master]GO--禁止访问的IPCREATE TABLE [dbo].[ForbiddenIP]([IP] [nvarchar](15) NOT NULL,[说明] [nvarchar](50) NULL,[设定时间] [datetime] NULL, CONSTRAINT [PK_ForbiddenIP] PRIMARY KEY CLUSTERED