03 2013 档案
摘要：drop proc proc_insertgocreate proc proc_insert (@tablename varchar(256))asbeginset nocount ondeclare @sqlstr varchar(4000)declare @sqlstr1 varchar(4000)declare @sqlstr2 varchar(4000)select @sqlstr='select ''insert '+@tablenameselect @sqlstr1=''select @sqlstr2=' ('sele
阅读全文
摘要：SqlServer数据库全角转半角CREATE FUNCTION f_Convert( @str NVARCHAR(4000), --要转换的字符串 @flag bit --转换标志,0转换成半角,1转换成全角 )RETURNS nvarchar(4000) AS BEGIN DECLARE @pat nvarchar(8),@step int,@i int,@spc int IF @flag=0 SELECT @pat=N'%[！-～]%',@step=-65248, @str=REP...
阅读全文
摘要：using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using System.IO; public partial Program{ public static void Main(string[] args) { HSSFWorkbook hssfworkbook = new HSSFWorkbook(); ISheet sheet = hssfworkbook.CreateSheet("sheet1");//创建工作表 IRow row = sheet.CreateRow...
阅读全文
