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

ÓÃVFP9.0ºÍSQL2000¹¹½¨C/S°æ±¾µÄÈËʹÜÀíϵͳ

±¾ÊµÀýÒ»Ì×ÈËʹÜÀíϵͳ£º¿ª·¢¹¤¾ßΪVFP9.0¡¢SQL2000¡¢EXCEL;ʹÓÃÁËAdobe PhotoshopÆ½ÃæÉè¼ÆÈí¼þ£¬²ÉÓÃÁËSPT´©Í¸¼¼Êõ£¬µ÷ÓÃÁËAPIº¯Êý£¬ÊµÏÖÁ˶Ôϵͳʱ¼äµÄͳһ¿ØÖÆ¡¢¶ÔDNSµÄ´úÂë¿ØÖÆ¡¢¶ÔÓòÃû½âÎöµÄÓ¦Ó㬵ȵÈ
ÔΣ¬ÔõôÉÏ´«£¬£¨°üº¬Ô´Âëδ±àÒëµÄ£©ÏëÒªµÄ¸øÎÒ·¢E-MAIL:zhao@tom.com


Ïà¹ØÎĵµ£º

c Ñ¡Ôñ½á¹¹1

/*ÓÃif¶à²ãǶÌ×ʵÏÖa£¬b£¬c´óСµÄÁùÖÖÅÅÐòÇé¿öa>b>c£¬a>c>b£¬c>a>b£¬c>b>a£¬b>c>a£¬b>a>c*/
#include<stdio.h>
void main()
{
  unsigned int a,b,c;
  printf("please input three numbers a,b,c:");
  scanf("%d%d%d",&a,&b,&c);
  if ......

¡¶Èí¼þ¿ª·¢ÐÔÄÜÓÅ»¯ÏµÁС·Ö®SqlÐÔÄÜÓÅ»¯(¶þ)

  Ò»¡¢SQLƴд½¨Òé 1¡¢²éѯʱ²»·µ»Ø²»ÐèÒªµÄÐС¢ÁÐ       ÒµÎñ´úÂëÒª¸ù¾Ýʵ¼ÊÇé¿ö¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý£¬×îС»¯½á¹û¼¯£¬ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØÊ¹ÓÃͨÅä·ûÈ磺select * from table1Óï¾ä£¬ÒªÓõ½¼¸ÁоÍÑ¡Ôñ¼¸ÁУ¬È磺select col1,col2 from table1;ÔÚ¿ÉÄܵÄÇé¿öϾ¡Á¿ÏÞÖÆ½á¹û¼¯ÐÐÊýÈ磺se ......

SQLÎÞÏÞ·Ö¼¶½á¹¹

×î½ü£¬ÒòΪÏîÄ¿µÄÔ­Òò£¬ÐèÒªÉè¼ÆÒ»¸öÊý¾Ý¿â£¬¸ÃÊý¾Ý¿âµÄ¹¦ÄÜÖ÷ÒªÊÇÃèÊöÎļþϵͳµÄ½á¹¹ºÍÎļþÐÅÏ¢£¬ÔÚÍøÉÏÕÒÁ˺ܶàµÄ×ÊÁÏ£¬µ«ÊÇÐí¶àÉè¼ÆÒªÃ´Õë¶Ô²éѯÁ¿±È½Ï¶àµÄÀ´×ö£¬ÒªÃ´Õë¶ÔÐ޸ġ¢²åÈëÁ¿±È½Ï¶àµÄÀ´×ö£¬¶ø¶ÔÓÚÎļþϵͳ¶øÑÔ£¬ËüµÄ²éѯ¡¢²åÈë¡¢Ð޸ͼÊÇÏ൱Ƶ·±µÄ£¬Òò´Ë£¬Êý¾Ý¿âµÄÉè¼Æ¼«ÆäÖØÒª,ÏÖ½«×Ô¼ºµÄÒ»µãÏ뷨˵˵£¬Ï£Íû´ ......

ÔÚSQLÓï¾ä²éѯ½á¹ûÖмÓÈë×ÔÔö³¤ÁÐ

Óï¾ä£ºselect rank() over(Order By ±íµÄÖ÷¼ü Desc) As UID ,ÆäËûÁÐ from ±í
˵Ã÷£ºrankº¯Êý
×÷Óãº
·µ»ØÖ¸¶¨Ôª×éÔÚÖ¸¶¨¼¯ÖеÄÅÅÃû£¨ÅÅÃû´Ó 1 ¿ªÊ¼£©
Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )
²ÎÊý£º
Tuple_Expression
Ò»¸öÓÐЧµÄ¶àά±í´ïʽ (MDX) Ôª ......

SQL³£Óú¯ÊýÖ®Èý REPLICATE () £¿


°´Ö¸¶¨´ÎÊýÖØ¸´×Ö·û±í´ïʽ¡£
Óï·¨
REPLICATE ( character_expression, integer_expression)
²ÎÊý
character_expression
×Ö·ûÊý¾ÝÐ͵Ä×ÖĸÊý×Ö±í´ïʽ£¬»òÕß¿ÉÒÔÒþʽת»»Îª nvarchar »ò ntext µÄÆäËûÊý¾ÝÀàÐ͵Ä×ÖĸÊý×Ö±í´ïʽ¡£
integer_expression
¿ÉÒÔÒþʽת»»Îª int µÄ±í´ïʽ¡£Èç¹û integer_expression Ϊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ