摘要:
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... 阅读全文
posted @ 2009-07-07 08:57
大宇MVP
阅读(157)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2009-07-07 08:56
大宇MVP
阅读(160)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2009-07-07 08:56
大宇MVP
阅读(446)
评论(0)
推荐(0)
摘要:
在C#的开发当中经常遇到关于一个日期时间"+/-"一段时间的问题,下面是个人的一些总结,供大家参考.DateTime dt = DateTime.Now; //当前时间DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一DateTime endWeek = startWeek... 阅读全文
posted @ 2009-07-07 08:55
大宇MVP
阅读(167)
评论(0)
推荐(0)