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

SqlServerÖÐÐбäÁÐ

     ÀýÈç´´½¨Ò»¸ö±í
                 create table stz
              (
             stuNO int  primary key ,
             subject nvarchar(20) not null,
             score int not null
              )
              insert into stz values(1000 ,'Êýѧ',90)
              insert into stz values(1001,'ÓïÎÄ',90)
              insert into stz values(1002,'Ó¢Óï',90)
              insert into stz values(1001 ,'Êýѧ',90)
              insert into stz values(1002,'ÓïÎÄ',90)
              insert into stz values(1000,'Ó¢Óï',90)
              insert into stz values(1002 ,'Êýѧ',90)
              insert into stz values(1000,'ÓïÎÄ',90)
              insert into stz values(1001,'Ó¢Óï',90)
--              ÏÖÔÚµÄÇé¿öÊÇ
            select * from stz;
                    &n


Ïà¹ØÎĵµ£º

SQLSERVERÓα꼰ѭ»·Óï¾ä

ÕûÀíһϣ¬¹ØÓÚÓα꣬MSDNÓУº
¹ý Transact-SQL ·þÎñÆ÷Óαê¼ìË÷ÌØ¶¨ÐС£
Transact-SQL Óï·¨Ô¼¶¨
 ²ÎÊý
NEXT
½ô¸úµ±Ç°Ðзµ»Ø½á¹ûÐУ¬²¢ÇÒµ±Ç°ÐеÝÔöΪ·µ»ØÐС£Èç¹û FETCH NEXT Ϊ¶ÔÓαêµÄµÚÒ»´ÎÌáÈ¡²Ù×÷£¬Ôò·µ»Ø½á¹û¼¯ÖеĵÚÒ»ÐС£NEXT ΪĬÈϵÄÓαêÌáȡѡÏî¡£
PRIOR
·µ»Ø½ôÁÚµ±Ç°ÐÐÇ°ÃæµÄ½á¹ûÐУ¬²¢ÇÒµ±Ç° ......

SQLServerµÄÁ½¸öά»¤¼¼ÇÉ

¡¡È·Êµ£¬Êý¾Ý¿âµÄά»¤³£³£½»¸øÄÇЩרҵµÄÊý¾Ý¿â¹ÜÀíÔ±£¬µ«ÊÇ×÷Ϊһ¸ö¿ª·¢Õߣ¬ÄãÒ²Ðíż¶ûÐèÒªÔÝʱ´ÓÊÂÕâ¸ö¹¤×÷¡£ËùÒÔ£¬ÊÔÒ»ÊÔÕâÁ½¸öSQL·þÎñÆ÷ά»¤¼¼ÇÉ£ºÇáËɸıäÊý¾Ý¿âÓµÓÐÕß¡¢ÕûÀíË÷ÒýË鯬¡£Ë­»áÏëµ½ÄãÉõÖÁ¿ÉÒÔ¸øÄÇЩÊý¾Ý¿â¹ÜÀíÔ±½ÌÉÏÒ»Á½¸öм¼ÇÉÄØ£¿ÖØÖ¸¶¨Êý¾Ý¿âÓµÓÐÕßµ±»Ø¸´»òÕßн¨Êý¾Ý¿âʱ£¬ÄãÓÐûÓÐ×¢Òâµ½SQL Server° ......

SqlServer,Oracle ³£Óú¯Êý±È½Ï


SqlServer,Oracle ³£Óú¯Êý±È½Ï
 
Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
¡¡¡¡ Sql Server: SELECT abs(-1) value
¡¡¡¡ Oracle: SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ Sql Server: SELECT ceiling(-1.001) value
¡¡¡¡ Oracle: SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
¡¡¡¡ Sql Server: SELECT f ......

SQLServerÊý¾Ý¿âÉè¼Æ±íºÍ×Ö¶Î(ת)

SQL ServerÊý¾Ý¿âÉè¼Æ±íºÍ×Ö¶Î
1. ԭʼµ¥¾ÝÓëʵÌåÖ®¼äµÄ¹ØÏµ
¡¡¡¡¿ÉÒÔÊÇÒ»¶ÔÒ»¡¢Ò»¶Ô¶à¡¢¶à¶Ô¶àµÄ¹ØÏµ¡£ÔÚÒ»°ãÇé¿öÏ£¬ËüÃÇÊÇÒ»¶ÔÒ»µÄ¹ØÏµ£º¼´Ò»ÕÅԭʼµ¥¾Ý¶ÔÓ¦ÇÒÖ»¶ÔÓ¦Ò»¸öʵÌå¡£ÔÚÌØÊâÇé¿öÏ£¬ËüÃÇ¿ÉÄÜÊÇÒ»¶Ô¶à»ò¶à¶ÔÒ»µÄ¹ØÏµ£¬¼´Ò»ÕÅԭʼµ¥Ö¤¶ÔÓ¦¶à¸öʵÌ壬»ò¶àÕÅԭʼµ¥Ö¤¶ÔÓ¦Ò»¸öʵÌå¡£ÕâÀïµÄʵÌå¿ÉÒÔÀí½âΪ»ù±¾±í¡£Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ