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

ÇóÒ»¸ö³É¹¦µÄMSSQLÊý¾Ý¿âÉè¼ÆÀý×Ó

  ´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
  ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏߵȡ£¡£¡£¡£¡£
ÒýÓÃ
  ´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
  ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏߵȡ£¡£¡£¡£¡£

Äã²»ÈçÈ¥ÍøÉÏϸöÏà¹ØµÄϵͳ¿´¿´È˼ÒÔõô¸ãµÄ.

Õâ¸öÒª½áºÏÄãµÄÐèÇó·ÖÎöÀ´


Äã¿ÉÒԲο¼Ò»ÏÂÍøÉÏÏÂÔØµÄϵͳ£¬È»ºó¸ù¾Ý×Ô¼ºµÄÐèÇóÀ´ÐÞ¸Ä

´ó¼ÒºÃŶ


Ïà¹ØÎÊ´ð£º

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»

SQL code:
select distinct *
from tablename
where id in (
selec ......

»ñµÃmssqlÊý¾Ý¼¯µÄÎÊÌâ

ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
  create  procedure add_pp_SqlPager
  @sqlstr nvarchar(4000),                --²éѯ×Ö· ......

mssql ¶à±í²éѯµÄÎÊÌâ

ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ    ÐÕÃû
1      Ëν­
2      ¬¿¡Òå

± ......

ÕÐÆ¸MsSQL DBA - ÉϺ£

ÓÐÒâÕßÇëÁªÏµyushan-33@hotmail.com / 18821146311

Microsoft SQL Administrator

Job Description:

A detail oriented Microsoft SQL Administratorwith excellent problem solving, analyti ......

×ÜÕ¾·ÖÕ¾MSSQL¿â½á¹¹

Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ