摘要： if object_id('dbo.fn_split')is not null drop function dbo.fn_splitgocreate function dbo.fn_split ( @inputstr varchar(8000), @seprator varchar(10) ) returns @temp table (a varchar(200)) as begin declar... 阅读全文

摘要： set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[proc_DataSelect]@tabelName varchar(100)asSELECT -- TableName=o.name,FieldId=c.colid,FieldName=c.name,FieldDescription=ISNULL(pfd.value... 阅读全文

摘要： set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo--exec sp_getdata2 'dealreports'--select * from [user]--use [ReportReal]ALTER proc [dbo].[sp_getdata2]@tabname varchar(50)asdeclare @oid intselect @oid=objec... 阅读全文

摘要： 在C#的开发当中经常遇到关于一个日期时间"+/-"一段时间的问题,下面是个人的一些总结,供大家参考.DateTime dt = DateTime.Now; //当前时间DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一DateTime endWeek = startWeek... 阅读全文