ÇóÒ»¸ö³É¹¦µÄMSSQLÊý¾Ý¿âÉè¼ÆÀý×Ó
´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏߵȡ£¡£¡£¡£¡£
Äã²»ÈçÈ¥ÍøÉÏϸöÏà¹ØµÄϵͳ¿´¿´È˼ÒÔõô¸ãµÄ.
Õâ¸öÒª½áºÏÄãµÄÐèÇó·ÖÎöÀ´
Äã¿ÉÒԲο¼Ò»ÏÂÍøÉÏÏÂÔØµÄϵͳ£¬È»ºó¸ù¾Ý×Ô¼ºµÄÐèÇóÀ´ÐÞ¸Ä
´ó¼ÒºÃŶ
Ïà¹ØÎÊ´ð£º
mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»
SQL code:
select distinct *
from tablename
where id in (
selec ......
ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --²éѯ×Ö· ......
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
± ......
ÓÐÒâÕßÇëÁªÏµyushan-33@hotmail.com / 18821146311
Microsoft SQL Administrator
Job Description:
A detail oriented Microsoft SQL Administratorwith excellent problem solving, analyti ......
Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......