Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

CodeSmith,SqlServer,C#ÖеÄÀàÐͶÔÕÕ

SQLServer          CodeSmith                            C#
bigint                    Int64           ......

ÓÃasp.net»¹Ô­Óë»Ö¸´sqlserverÊý¾Ý¿â

  
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹Ô­ºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ­×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô­»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô­£¬»¹Ô­µÄʱºòÎÊÌ ......

ÓÃasp.net»¹Ô­Óë»Ö¸´sqlserverÊý¾Ý¿â


  
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹Ô­ºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬
È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ­×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô­»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô­£¬»¹Ô­µÄʱºòÎÊÌâ ......

SQLSERVER ·ÖÒ³

select   identity(int,1,1) as col_id , *   into   temp   from  uep.dbo.A_experiment 
select   *   from temp where   col_id   between   50   and   60
drop  table temp ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ