/**//*验证身份证算法By:刘志伟2008-1-29与天津*/CREATE FUNCTION [fn_ValidateIDC](@idc varchar(18))RETURNS BITASBEGINIF LEN(@idc)<>15 AND LEN(@idc)<>18--身份证号只有15或18位RETURN(0)IF LEN(@idc)=15 --如果是15位身份证 则只验证日期和是否数字格式 IF ISDATE('19'+SUBSTRING(@idc,7,6))=0 OR ISNUMERIC(@idc)=0 RETURN(0) ELSE RETURN(1)/**//*18位身份证 验证日期 校验位*/IF ISDATE(SUBSTRING(@idc,7,8))=0 OR ISNUMERIC(SUBSTRING(@idc,1,17))=0--验证日期和前17位是否数字格式 RETURN(0)/**//*验证校验位开始*/DECLARE @validFactors VARCHAR(17),@validCodes VARCHAR(11),@i TINYINT,@iTemp INTSELECT @validFactors='79A584216379A5842',@validCodes='10X98765432',@i=1,@iTemp=0WHILE @i<18 BEGIN &n… 阅读全文>>
所属分类：默认分类评论(0)|阅读 (38)|分享(0)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>RSS</title><style type="text/css">...a{...}{color:black;}a:hover{...}{color:Green;}a:active{...}{color:Red;}a:link{...}{color:Blue;}</style><script chartset="utf-8">...function $(objectid)...{return document.getElementById(objectid);}var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");xmlDoc.async="false";xmlDoc.load("http://news.qq.com/now.xml");//"http://news.baidu.com/n?cmd=4&class=internet&pn=1&tn=rss");var nodes=null;var hasData=true;var array;nodes = xmlDoc.selectNodes("/rss/channel/item");if(nodes==null)...{hasData… 阅读全文>>
所属分类：默认分类评论(0)|阅读 (34)|分享(0)
--前一天SELECT * FROM [tb] WHERE [日期字段] BETWEEN DATEADD(DAY,-1,CONVERT(VARCHAR(8),GETDATE(),112)) AND DATEADD(MILLISECOND,-2,CONVERT(VARCHAR(8),GETDATE(),112))--上一个月SELECT * FROM [tb] WHERE [日期字段] BETWEEN DATEADD(MONTH,-1,DATEADD(DAY,1-DAY(GETDATE()),CONVERT(VARCHAR(8),GETDATE(),112)))ANDDATEADD(MILLISECOND,-2,DATEADD(DAY,1-DAY(GETDATE()),CONVERT(VARCHAR(8),GETDATE(),112)))--上一年SELECT * FROM [tb] WHERE [日期字段]BETWEEN DATEADD(YEAR,-1,DATEADD(DAY,1-DATEPART(dayofyear,GETDATE()),CONVERT(VARCHAR(8),GETDATE(),112)))AND DATEADD(MILLISECOND,-2,DATEADD(DAY,1-DATEPART(dayofyear,GETDATE()),CONVERT(VARCHAR(8),GETDATE(),112))) 阅读全文>>
所属分类：默认分类评论(0)|阅读 (34)|分享(0)
由于用SQL语句中的BACKUP DATABASE 数据库名 TO DISK =存储路径 在ASP.NET或其他编程语言中存在权限不够不能读写存储路径的问题 或者可以备份但在还原时由于正在打开数据库连接因此不能够正确还原针对以上问题 可以通过SQLServer的SQLDMO.DLL来实现备份与还原以下是从网络上找的材料写的ASP.NET中的备份与还原的类 经实验可以实现备份与还原首先当然得添加引用 在网站-》添加引用 COM 找到 MICROSOFT SQLSERVER SQLDMO library 添加然后添加一个类DBService内容如下 using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;/**//// <summary>/// DBService 的摘要说明/// </summary>public class DBService...{public DBService()...{ // // TODO: 在此处添加构造函数逻辑 //}/**//// <summary>/// 数据库备份… 阅读全文>>
所属分类：默认分类评论(0)|阅读 (24)|分享(0)
IF OBJECT_ID('t_Test','U') IS NOT NULLDROP TABLE t_TestCREATE TABLE t_Test([id] INT UNIQUE NOT NULL,[name] NVARCHAR(20),[grade] DECIMAL(8,2),);INSERT INTO [t_Test] VALUES(1,N'一班',100.0);INSERT INTO [t_Test] VALUES(2,N'二班',90.5);INSERT INTO [t_Test] VALUES(3,N'一班',90.5);INSERT INTO [t_Test] VALUES(4,N'二班',70.0);INSERT INTO [t_Test] VALUES(5,N'二班',55.5);INSERT INTO [t_Test] VALUES(6,N'三班',95.0);INSERT INTO [t_Test] VALUES(7,N'一班',90.5);INSERT INTO [t_Test] VALUES(8,N'二班',80.0);INSERT INTO [t_Test] VALUES(9,N'二班',80.0);INSERT INTO [t_Test] VALUES(10,N'三班',90.0);INSERT INTO [t_Test] VALUES(11,N'二班',100.0);INSERT INTO [t_Test] VALUES(12,N'一班',85.0);SELECT *,[ROW_NUMBER()]=ROW_NUMBER() OVER(PARTITION BY [name] ORDER BY [grade]),[RANK()]=RANK() OVER(PARTITION BY [name] ORDER BY [grade]),[DENSE_RANK()]=DENSE_RANK() OVER(PARTITION BY [name] ORDER BY [grade]),[NTILE()]=NTILE(4) OVER(PARTITION BY [name] ORDER BY [grade]) FROM t_Test;DROP TABLE t_Test; 阅读全文>>
所属分类：默认分类评论(0)|阅读 (25)|分享(0)
