SQL²éѯ·ÖÎöÆ÷Íâ¹ÒÔ´Âë·ÖÏí
±¾ÈËдÁËÒ»¸öSQL²éѯ·ÖÎöÆ÷À©Õ¹¹¤¾ß£¬¹¦ÄÜÀàËÆDelphiµÄToDo¡£¿ÉÒÔ·½±ã¿ª·¢ÕßÔÚ´óÁ¿µÄSQL½Å±¾ÖпìËÙÕÒµ½Ã¿¸öÄ£¿é¡¢To-Do£¬´Ó¶øÌá¸ß¿ª·¢¸ßÀûÂÊ¡£
ʹÓõÄʱºòÏÈÔËÐÐSQL²éѯ·ÖÎöÆ÷£¬È»ºóÔËÐб¾³ÌÐò¼´¿É£¨¿ÉÒÔ¹¤¾ß|×Ô¶¨ÒåÖÐÅäÖã©¡£°´F2ÏÔʾTo-Do List´°¿Ú£¬°´Alt+F2ÔÚµ±Ç°Î»ÖòåÈëTo-Do¡£
ÓÉÓÚʱ¼ä¹ØÏµ£¬±¾³ÌÐò²¢Î´ÍêÉÆ£¬ÔÚË«»÷To-Do ItemºóӦûÓн«¹â±ê¶¨Î»µ½¶ÔÓ¦µÄλÖã¬Ï£Íû¸ßÊִͽ̣¬ÓÐÐËȤµÄÅóÓѲ»·À¼ÌÐøÍêÉÆËü£¬²¢·¢Ò»·ÝÔ´Âë¸øÎÒ¡£Íò·Öлл¡££¨QQ£º462400756£©
{================================================================}
{ todo.dpr
{================================================================}
program todo;
{%ToDo 'todo.todo'}
uses
Forms,
windows,
messages,
tdmain in 'tdmain.pas' {frmToDoMain},
tdcontainer in 'tdcontainer.pas' {frmContainer},
tdItem in 'tdItem.pas' {frmItem},
tdFilter in 'tdFilter.pas' {frmFilter};
{$R *.res}
var
h: Hwnd;
begin
Application.Initialize;
h := FindWindow(nil, PChar('frmContainer'));
if h = 0 then
begin
Application.CreateForm(TfrmContainer, frmContainer);
Application.CreateForm(TfrmToDoMain, frmToDoMain);
Application.CreateForm(TfrmItem, frmItem);
Application.CreateForm(TfrmFilter, frmFilter);
Application.ShowMainForm := False;
end;
h := FindWindow(nil, PChar('frmContainer'));
SendMessage(h, WM_RERUN, 0, 0);
Application.Run;
end.
{================================================================}
{ tdmain.pas
{================================================================}
unit tdmain;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ComCtrls, RegExpr, Tabs, Menus, StdCtrls, ImgList,
Grids, ExtCtrls;
type
TViewType = (vtTodo, vtModule);
TGroupType = (gtOwner, gtCategory);
TfrmToDoMain = class(TForm)
 
Ïà¹ØÎĵµ£º
1 ǰÑÔ
¿Í·þÒµÎñÊܵ½SQLÓï¾äµÄÓ°Ïì·Ç³£´ó£¬ÔÚ¹æÄ£±È½Ï´óµÄ¾Öµã£¬ÍùÍùÒòΪһ¸öСµÄSQLÓï¾ä²»¹»ÓÅ»¯£¬µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ£¬Ð¡ÐÍ»úidleËùÊ£ÎÞ¼¸£¬Ó¦Ó÷þÎñÆ÷¶ÏÁ¬¡¢³¬Ê±£¬ÑÏÖØÓ°ÏìÒµÎñµÄÕý³£ÔËÐС£Òò´Ë£¬³ÆµÍЧµÄSQLÓï¾äΪ¿Í·þÒµÎñµÄ‘¶ñÁú’²¢²»¹ý·Ö¡£Êý¾Ý¿âµ ......
1.²éѯ³öµ±Ç°Á¬½ÓÈ»ºó½«Æä¹Ø±Õ
select spid
from master.dbo.sysprocesses
where dbid= db_id('Êý¾Ý¿âÃû')
--db_id('DoNet')
Èçspid ֵΪ 52.
2. 執ÐÐ:
kill 52
3.ÐÞ¸Ä數據庫Ãû
EXEC sp_dboption 'old_db_name', 'Single User', 'false'
&nb ......
Ò»¡¢Í¨¹ýÆóÒµ¹ÜÀíÆ÷½øÐе¥¸öÊý¾Ý¿â±¸·Ý¡£´ò¿ªSQL SERVER ÆóÒµ¹ÜÀíÆ÷£¬Õ¹¿ªSQL SERVER×éLOCALϵÄÊý¾Ý¿â£¬ÓÒ¼üµã»÷ÄãÒª±¸·ÝµÄÊý¾Ý¿â£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡ÔñËùÓÐÈÎÎñϵı¸·ÝÊý¾Ý¿â£¬µ¯³ö±¸·ÝÊý¾Ý¿â¶Ô»°¿ò£º
µã»÷Ìí¼Ó°´Å¥£¬Ìîд±¸·ÝÎļþµÄ·¾¶ºÍÎļþÃû£¬µã»÷È·¶¨Ìí¼Ó±¸·ÝÎļþ£¬µã»÷±¸·Ý¶Ô»°¿òÉϵı¸·Ý£¬¿ªÊ¼½øÐб¸·Ý¡£
&nbs ......
ÔÚ²éѯ·ÖÎöÆ÷ÒÔ“Îı¾ÏÔʾ½á¹û”·½·¨Ö´ÐÐ
exec UspOutputData ÄãµÄ±íÃû
µÃµ½µ¼³öÊý¾ÝµÄÓï¾ä£¬µ«image,text,ntext,sql_variant Áв»³öÏÖÔÚÓï¾ä£¬ÒÔºó¸Ä½ø¡£
´æ´¢¹ý³ÌUspOutputDataÈçÏ£º
CREATE PROCEDURE  ......