2010 年 9月随笔档案 - fery

C#获取客户端UTC时间及其总毫秒数解决方案

摘要：/// <summary>/// Convert DateTime To Milliseconds/// </summary>/// <param name="dt">the datetime</param>/// <returns></returns>public static long GetTotalTolMillise... 阅读全文

posted @ 2010-09-12 00:41 fery 阅读(978) 评论(0) 推荐(0)

将行编号转换为一个字符串解决方案

摘要：DECLARE @Results VARCHAR(MAX)SELECT @Results = ( SELECT TOP 10 CAST(tn.NewsId AS VARCHAR) + ',' FROM dbo.TB_News tn ORDER BY tn.NewsId DESC FOR XML PATH('') )SELECT @Results---注意：PATH 括号及括号中参数为非必填项，设置... 阅读全文

posted @ 2010-09-12 00:35 fery 阅读(189) 评论(1) 推荐(0)

利用XML向存储过程传递复杂参数解决方案

摘要：IF EXISTS ( SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[CreateScheduleConference]') AND TYPE IN (N'P', N'PC') ) DROP PROCEDURE [dbo].[CreateScheduleConference]GOCREATE PROC [dbo].[C... 阅读全文

posted @ 2010-09-11 23:52 fery 阅读(270) 评论(0) 推荐(0)