摘要：转自：http://blog.csdn.net/dinglang_2009/article/details/6951138using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Collections;using System.Reflection;namespace DatableToList{ class ConvertHelper<T> where T : new() { /// <summar... 阅读全文

摘要：Declare @Oid int Declare @PriceTotal float--定义游标Declare cur cursor forSelect Oid from orders where oid in (select oid from ochild where Ochild.MID = @ProductSN) And Orders.PID = @SupplierSN And (Orders.LastDate >= @StartDate) And (Orders.LastDate <= @EndDate)--打开游标open cur--植入变量fetch ... 阅读全文

摘要：public int GetHashCode(string s) { int hash = 5381; int len = s.Length; for (int i = 0; i < len; i++) { int c = Convert.ToInt32(s[i]); hash = ((hash << 5) + hash) ^ c; } return hash; } 阅读全文

摘要：Create proc killspid (@dbname varchar(20)) as begin declare @sql nvarchar(500) declare @spid int--SPID 值是当用户进行连接时指派给该连接的一个唯一的整数 set @sql= 'declare getspid cursor for select spid from sysprocesses where dbid=db_id( '''+@dbname+ ''') ' --sysprocesses 包含有关 SQL ... 阅读全文