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

´ÓËã·¨ÈëÊÖ½²½âSQL ServerµÄµäÐÍʾÀý

 ServerÊý¾Ý¿âÖÐʵÏÖ×îÓÅ×î¼òµÄÕû¸ö¹ý³Ì¡£
Ëã·¨ÊǼÆËã»ú¿ÆÑ§ÖÐÒ»¸öÖØÒªµÄÑо¿·½Ïò£¬Êǽâ¾ö¸´ÔÓÎÊÌâµÄ¹Ø¼ü¡£ÔÚ¼ÆËã»úÊÀ½çÖУ¬Ëã·¨ÎÞ´¦²»ÔÚ¡£Êý¾Ý¿âÊÇ´æ´¢Êý¾ÝºÍÖ´ÐдóÅúÁ¿¼ÆËãµÄ³¡Ëù£¬ÔÚÊý¾Ý¿âÖÐʹÓÃһЩ¼òµ¥µÄSQLÃüÁ½øÐд洢¡¢²éѯ¡¢Í³¼Æ¡¢ÒÔ½â¾öÏÖʵÊÀ½çÖеÄÎÊÌâÒѾ­ÊÇÂżû²»ÏÊ¡£Ëæ×ÅÊý¾ÝÁ¿µÄ´ó·ù¶ÈÔö¼ÓºÍÒµÎñ¹æÔòµÄÈÕÒæ¸´ÔÓ£¬Ô½À´Ô½ÐèÒªÒ»ÖÖרÃŵķ½·¨À´Âú×ãЧÂʺÍ׼ȷÐÔ·½ÃæµÄÒªÇó¡£ÈçºÎ°Ñ½â¾öÎÊÌâµÄ¸´ÔÓË㷨ת»»ÎªÊý¾Ý¿âÄܹ»Ö´ÐеÄÃüÁҲÊÇÊý¾Ý¿âÓ¦Óü¼ÊõÑо¿µÄÒ»¸ö·½Ãæ¡£±¾ÎÄÒÔMSSQLÖеÄÃüÁîÀ´²ûÊöÀý×Ó¡£
Êý¾Ý¿âÖпÉÒԴ洢ʵÌåµÄÊý¾Ý¼¯ºÏ£¬ÔÚ½øÐÐÔËËãʱ£¬Êý¾Ý¿âʹÓÃÅúÁ¿¼ÆËãµÄ·½·¨À´´¦ÀíÊý¾Ý£¬ÅúÁ¿µÄ´Ó´æ´¢É豸É϶ÁÈ¡Êý¾Ý£¬´¦ÀíÖ®ºóÓÖÅúÁ¿µÄд»Ø´æ´¢É豸¡£ÓеÄÊý¾Ý¿âÌṩÁËÓα꣬Óαê¿ÉÒÔ¶ÁÈ¡³ö±íÖÐÒ»ÐеÄÊý¾ÝÖеÄÿһ¸ö×ֶΣ¬¶ÔÕâЩ×ֶνøÐи´ÔÓµÄÒµÎñ¹æÔò¼ÆË㣬ȻºóÔÙд»ØÊý¾Ý¿âÖС£ÓëʹÓÃÅúÁ¿µÄ·½·¨±È½Ï£¬ÅúÁ¿¼ÆËãµÄ·½·¨ÏûºÄµÄ×ÊÔ´Ïà¶Ô±È½ÏÉÙ£¬¶øÊ¹ÓÃÓαêÔòÕ¼ÓÃÌ«¶àµÄ×ÊÔ´£¬ËٶȱȽÏÂý£¬Ð§ÂʽϵͲ¢ÇÒ»¹ÓмÓËøÌõ¼þµÈÐí¶àµÄÏÞÖÆ¡£
±ÈÈç¶ÔÓÚÊý¾Ý¿âÖд洢ÁËѧÉú³É¼¨student_Score(sno,cno,score,level)£¬³É¼¨´Ó0·Öµ½100·Ö²»µÈ£¬Èç¹ûÐèÒªÔÚ·ÖÊýµÄºóÃæ´æ´¢Ò»¸ö×Ö¶Î×ÖlevelÀ´ËµÃ÷³É¼¨µÄÓÅÁÓ£¬90·ÖÒÔÉϵÄA£¬80-90·ÖΪB£¬60-80·ÖµÄΪC£¬60·ÖÒÔϵÄΪD£¬ÒÔÏÂÓм¸ÖÖËã·¨¶¼¿ÉÒԴﵽͬÑùµÄÄ¿±ê£º
1.¶¨ÒåÒ»¸öÓα꣬ѡÔñstudent_Score±íÖÐËùÓеijɼ¨¼Ç¼£¬¶¨ÒåÒ»¸ö´æ´¢³É¼¨µÄ±äÁ¿@cur_score£¬´æ´¢µ±Ç°¼Í¼µÄ·ÖÊý£¬¶¨ÒåÒ»¸ö´æ´¢µ±Ç°·ÖÊýËùÔڳɼ¨¼¶±ðµÄ±äÁ¿@cur_level£¬ÓÃÒÔ´æ´¢³É¼¨ºÃ»µµÄ±ê¼Ç¡£Ëã·¨ÈçÏ£ºÈç¹ûÓαêÖеļͼ²»Îª¿Õ£¬´ÓÓαêÖÐÈ¡³öµ±Ç°¼Í¼µÄ³É¼¨£¬Åжϳɼ¨ËùÔڵķÖÊý¶Î£¬°Ñ½á¹û´æ´¢ÔÚ±äÁ¿@cur_levelÖУ¬ÒÔ@cur_levelÖеÄÖµ¸üе±Ç°¼Í¼ÖеÄlevel×ֶΡ£Õû¸ö¹ý³ÌÐèÒªÖÁÉÙ¶ÁÈ¡Êý¾Ý¿âÁ½´Î£¬Ò»´ÎΪ»ñµÃ¼Í¼£¬Ò»´ÎÐèҪдÈëÊý¾Ý¿â£¬Ã¿Ìõ¼Ç¼¶¼ÐèÒª¾­¹ýÕâ¸ö¹ý³Ì£¬Ð§ÂÊÏà¶ÔµÍ¡£
2.ÒÀ´ÎÅúÁ¿¸üÐÂÊý¾Ý¿â£¬°ÑËùÓеÄlevel×ֶεÄÖµÉèÖÃΪD£¬ÔٴθüÐÂÊý¾Ý¿â£¬°Ñ³É¼¨´óÓÚµÈÓÚ60µÄ¼Í¼µÄLevel×ֶθüÐÂΪC£¬ÒÀ´Î¸üÐÂB¡¢A¡£ÕâÑù×öµÄÒ»¸öȱµãÊÇÓÐЩ¼Í¼µÄLevel×ֶα»¸üжà´Î£¬±ÈÈçÒ»¸ö¼Ç¼×îºóµÄLevel×ֶεÄÖµÊÇA£¬ÔòËüÊ×Ïȱ»¸üÐÂΪD£¬ÒÀ´Î±»¸üÐÂΪC¡¢B¡¢A¡£ÕâÐ©ÖØ¸´µÄ¸üÐÂÊÇ¿ÉÒÔ±»Ïû³ýµÄ£¬°ÑËã·¨¸Ä½øÒ»Ï¾ͿÉÒÔÊ¡È¥ÖØ¸´¸üÐµĻ¨·Ñ¡£¸üкóµÄËã·¨ÊÇÕâÑùµÄ£¬°Ñ³É¼¨½éÓÚ0ºÍ60·ÖµÄ¼Í¼µÄLevel×ֶθüÐÂΪD£¬ÒÀ´Î¸üи÷¸ö·ÖÊý¶ÎµÄ³É¼¨¡£ÊµÏÖµÄÕâÖÖËã·¨


Ïà¹ØÎĵµ£º

SQL ±êÁ¿Öµº¯ÊýµÄµ÷ÓÃ

µ÷Óà MS SQL ±êÁ¿Öµº¯Êý£¬Ó¦¸ÃÔÚº¯ÊýÇ°Ãæ¼ÓÉÏ "dbo."£¬·ñÔò»á±¨ “²»ÊÇ¿ÉÒÔʶ±ðµÄ ÄÚÖú¯ÊýÃû³Æ”´íÎó¡£ÀýÈç
    DECLARE @WhichDB TINYINT;
    SELECT @WhichDB = user_GetWhichDB(1);--¿´¿´ÊÇÄĸöÊý¾Ý¿âµÄ
=================================================
-- ......

¶ÔSQL˵²»£¡NoSQLµÄÊý¾Ý¿â¼¼Êõ¸ïÃü

¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
    ¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·­»ºÂý¶ø°º¹óµÄ¹ØÏµÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......

Ò»¸ösql·ÖÒ³µÄ´æ´¢¹ý³Ì

 CREATE  procedure SqlPager_Ex
 @sqlstr varchar(8000), --²éѯ×Ö·û´®
  @currentpage int, --µÚNÒ³
  @pagesize int --ÿҳÐÐÊý, 
 as
  set nocount on
  declare @P1 int, --P1ÊÇÓαêµÄid
   @rowcount int
  exec sp_cursorope ......

SQLÒ»¸ö´æ´¢¹ý³Ìµ÷ÓÃÁíÒ»¸ö´æ´¢¹ý³Ì »ñµÃ·µ»ØÖµÎÊÌâ

 µÚÒ»ÖÖ·½·¨: ʹÓÃoutput²ÎÊý
USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.usp_GetList', 'P' ) IS NOT NULL
    DROP PROCEDURE Production.usp_GetList;
GO
CREATE PROCEDURE Production.usp_GetList @product varchar(40)
    , @maxprice money
  &nb ......

MS SQL 2000 °²È«ÉèÖÃ

¡¡¡¡ÈÕǰSQL INJECTIONµÄ¹¥»÷²âÊÔÓúÑÝÓúÁÒ£¬ºÜ¶à´óÐ͵ÄÍøÕ¾ºÍÂÛ̳¶¼Ïà¼Ì±»×¢Èë¡£ÕâÐ©ÍøÕ¾Ò»°ãʹÓõĶàΪSQL SERVERÊý¾Ý¿â£¬ÕýÒòΪÈç´Ë£¬ºÜ¶àÈË¿ªÊ¼»³ÒÉSQL SERVERµÄ°²È«ÐÔ¡£ÆäʵSQL SERVER 2000ÒѾ­Í¨¹ýÁËÃÀ¹úÕþ¸®µÄC2¼¶°²È«ÈÏÖ¤-ÕâÊǸÃÐÐÒµËùÄÜÓµÓеÄ×î¸ßÈÏÖ¤¼¶±ð£¬ËùÒÔʹÓÃSQL SERVER»¹ÊÇÏ൱µÄ°²È«µÄ¡£µ±È»ºÍORCAL¡¢DB2µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ