摘要：创建日志表CREATE TABLE [dbo].[Log]( [ID] [int] IDENTITY(1,1) NOT NULL, [Date] [datetime] NOT NULL, [Thread] [varchar](255) NOT NULL, [Level] [varchar](20) NOT NULL, [Logger] [varchar](255) NOT NULL, [Message] [varchar](4000) NOT NULL) ON [PRIMARY]--------------------------------------------------------配. 阅读全文

摘要：with t as (select id,uid,name,count(id) over (partition by userlist.id) r from userlist)select * from t where r>1如果要查询不重复的记录则with t as (select id,uid,name,rank() over (partition by userlist.id order by userlist.id desc) r from userlist)select * from t where r=1 阅读全文

摘要：1、用sa账号登陆，执行以下脚本create login [beyondbit] with password='P@$$w0rd1'goCREATE USER [beyondbit] FOR LOGIN [beyondbit] WITH DEFAULT_SCHEMA=[dbo]GOexec sp_addrolemember 'db_owner', 'beyondbit'go2、用sa账号查看 安全性》登录名》beyondbit》右键属性，选择用户映射，勾选要映射的数据库，在下方数据库角色成员里选择db_owner和public这样beyondbi 阅读全文

摘要：将下面的文本保存为office2007.reg，然后倒入到注册表，这样office2007也能打开公司痕迹保留控件了Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Document.8]"BrowserFlags"=dword:80000024[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.RTF.8]"BrowserFlags"=dword:80000024[HKEY_LOCAL_MACHINE\SOFTWAR 阅读全文