摘要：分类类型表:CREATE TABLE [dbo].[Web_CategoryType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,CONSTRAINT [PK_Web_CategoryParent] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO分类表:CREATE TABLE [dbo].[Web_Category]( [ID] 阅读全文

摘要：--查询服务中的数据库和MDF,LOG文件的所在位置use masterselect a.*,b.* from sys.sysdatabases a inner join sys.sysaltfiles b on a.dbid = b.dbid--查看服务器中各数据库状态exec sp_helpdb 阅读全文

摘要：/// <summary> ......///<summary>///获取当前请求的IP地址///</summary>///<returns></returns>publicstaticstringGetIP(){ HttpRequest request = HttpContext.Current.Request; string ipAddress=string.Empty; if(request.ServerVariables["HTTP_X_FORWARDED_FOR"]==null || request.Se 阅读全文