SqlServerÓαêÀí½â
Óαê²Ù×÷µÄÁù²½Öè:
¡ôÔÚÿ´ÎÔÚ´´½¨ÓαêµÄʱºò¶¼ÎÊÎÊ×Ô¼º,ÓÃʲô±ðµÄ·½·¨¿ÉÒÔ±ÜÃâʹÓÃÓαê,ÄÇôÄã¾Í²½ÈçÉè¼ÆµÄÕý¹æÁË.
1.ÉùÃ÷
2.´ò¿ª
3.Ó¦ÓÃ/²Ù×÷
4.¹Ø±Õ.
5.ÊÍ·Å
ÉùÃ÷ÓαêµÄ»ù±¾Óï·¨ÈçÏÂ:
Declare <cursor name> cursor
For <select statement>
°¸Àý1: MySchool
if exists(select * from sysobjects where name='cursc')
drop proc cursc
Go
create procedure cursc
as
declare
@question varchar(210), --ÎÒÃDZØÐëÉùÃ÷±äÁ¿À´´æ·ÅµÃµ½µÄ¼Ç¼
@a varchar(50),
@b varchar(50),
@c varchar(50),
@d varchar(50),
@answer varchar(50),
@num int
declare MyCursor cursor --ÉùÃ÷ÎÒÃǵÄÓαê
Global --È«¾Ö ÓαêµÄ·¶Î§»¹ÓÐÒ»¸öÊǾֲ¿(Local)
for select question ,OptionA,OptionB,OptionC,OptionD,Answer from question --¶ÔÓ¦µÄSQLÓï¾ä ºóÃæ´ò¿ªÓαê¾ÍÊÇ´ò¿ª
set @num=1 --ÉèÖñêÁ¿±íʾÓαêµÄÒÆ¶¯
open MyCursor --´ò¿ªÎÒÃǵÄÓαêÕâʵ¼ÊÖ´ÐÐÁËFor´Ó¾äµÄÖ÷Ìå²éѯ,µ«ÎÒÃÇÈÔȻûÓн«Êý¾Ý
--·ÅÔÚºÏÊʵÄλÖýøÐкÏÊʵĴ¦Àí,Òò´ËÎÒÃÇÐèÒª´¦ÀíÒ»×éÊÂÇé.
--1.»ñÈ¡µÚÒ»ÌõÀí·»òÕßFetch
&n
Ïà¹ØÎĵµ£º
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬
È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌâ ......
ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......
´¥·¢Æ÷µÄ¶¨ÒåÓë·ÖÀà:
Ö»Òª´¥·¢Æ÷ËùÔÚ±íÉϵĶÔӦʱ¼ä·¢Éú,¾Í»á×Ô¶¯Ö´Ðиô¥·¢Æ÷µÄ´úÂë.ʵ¼ÊÉÏ,ÎÒÃDz¢²»ÄÜÖ±½Óµ÷Óô¥·¢Æ÷,ΨһµÄ·½·¨ÊÇÔÚ·ÖÅäŶ´¥·¢Æ÷µÄ±íÉÏÖ´ÐÐijÖÖÐÐΪ·½¿É¼¤»î´¥·¢Æ÷. [´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì,ËûÔÚÖ´ÐÐÌØ¶¨µÄÓïÑÔʼþʱÉúЧ
& ......