SqlServer强制断开数据库已有连接的方法(转)
摘要：在master数据库中执行如下代码declare @i INT declare cur cursor for select spid from sysprocesses where db_name(dbid)= ''Your_Database_Name' open cur fetch next from cur into @i while @@fetch_status=0 begin exec('kill '+@i) fetch next from cur into @i end close cur deallocate cur
阅读全文
posted @
2013-08-23 09:14
garfieldtom
阅读(3066)
推荐(0) 编辑
cxGrid显示行号
摘要：定义一个类：TMyCxGrid = class(TObject) class procedure DrawIndicatorCell( Sender: TcxGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxCustomGridIndicatorItemViewInfo; var ADone: Boolean); end;class procedure TMyCxGrid.DrawIndicatorCell(Sender: TcxGridTableView; ACanvas: TcxCanvas; AViewInfo: Tcx...
阅读全文
posted @
2013-08-05 16:34
garfieldtom
阅读(1754)
推荐(0) 编辑
