摘要：
/// <summary> /// Excel导出写入 /// </summary> public class ExcelHelper { /// <summary> /// 当前行号【从0开始】 /// </summary> public int rowIndex = 0; /// <summary> /// Excel实例 /// </summary> private Workbook book = null; /// <summary>... 阅读全文
摘要：
--1.备份主数据库backup database testto disk ='D:\test.bak';--2.还原备份，生成镜像数据库(镜像服务器)Restore database testfrom disk='D:\test.bak'with NoRecovery,--保持数据一直处于恢复状态move 'Test' to 'd:\test.mdf',move 'Test_log' to 'd:\test_log.ldf';--3.1创建日志传端口create endpoint Mirrorin 阅读全文
摘要：
create table #tb(name varchar(32),kechen varchar(32),score float); insert into #tb values('小明','数学',99) insert into #tb values('小明','英语',60) insert into #tb values('小明','语文',100) insert into #tb values('小强','数学',29) insert into #tb valu 阅读全文
摘要：
output 可以把对表的：添加，删除，更新操作数据插入临时表。create table #tb(id int,name varchar(32));declare @tb table(id int,name varchar(32));/* 添加insert into #tb(id,name) output inserted.id,inserted.name into @tb values(1 ,'AAA' ) *//* 删除delete #tboutput deleted.id,deleted.name into @tb where id=1*/--更新update #tb.. 阅读全文
摘要：
public class SharpZipHelper { /// <summary> /// 压缩率：0-9 /// </summary> private int compressionLevel = 5; private byte[] buffer = new byte[2048]; /// <summary> /// 压缩文件 /// </summary> /// <param name="fileToZip">要压缩的文件路径</param... 阅读全文