200·ÖÇó´´½¨ÁÙʱ±í£¨sqlserver£©
±ÈÈçsqlÓï¾äÊÇ£º SQL code: select top 300 CA01.A_id as '±ä¶¯´ÎÊý', CA01.A0188 as 'ÈËÔ±id', CA01.apname as 'ÉóÅúÕß', CA01.CA0100 as 'È·ÈÏ״̬', CA01.CA0101 as '±ä¶¯ÀàÐÍ', CA01.CA0102 as 'ÉêÇë±ä¶¯ÈÕÆÚ' from CA01 ÓÐÁ½¸öÎÊÌ⣺ 1£º Òª°Ñ²éѯ³öÀ´µÄÊý¾Ý·Åµ½Ò»¸öбíÖÐ 2£º ËäÈ»ÓÐas £¬µ«ÊÇбíÖеÄ×Ö¶ÎÃû³ÆÈÔÈ»ÊÇÔ±íÖеÄ×Ö¶ÎÃû³Æ
²»Èüӷ֣¬Áí¿ªÐÂÌù¼Ó·Ö select top 300 CA01.A_id, CA01.A0188, CA01.apname, CA01.CA0100, CA01.CA0101, CA01.CA0102 into #tmp from CA01 ÏȰÑÊý¾Ý·Åµ½Ð±íÖУ¬È»ºóÔÚ½øÐÐͳ¼Æ sqlÓï¾äÊDz»¹Ì¶¨µÄ ¾ÍÊÇ˵Ҫ²éѯµÄ×Ö¶ÎÊDz»¹Ì¶¨µÄ£¬µÃÏȰÑÊý¾Ý·Åµ½Ò»ÕÅбíÖУ¬È»ºóÔÙ¶ÔÊý¾Ý½øÐвéѯ£¬ÉÏÃæµÄsqlÓï¾äºÜ¼òµ¥£¬¿ÉÄÜ»áÓбȽϸ´ÔӵijöÏÖ£¬±ÈÈçÓï¾äÖдøÓÐ×Ó²éѯÒýÓà ÏȰÑÊý¾Ý·Åµ½Ð±íÖУ¬È»ºóÔÚ½øÐÐͳ¼Æ ÒýÓà sqlÓï¾äÊDz»¹Ì¶¨µÄ °ÑÄãµÄ±í½á¹¹¡¢²âÊÔÊý¾ÝºÍÄãÒªµÄ½á¹ûÌù³öÀ´ 1027480591 ¼ÓÎÒqq˵°É Çé¿ö±È½Ï¸´ÔÓ£¬ºÇºÇ SQL code: select top 300 CA01.A_id, CA01.A0188, CA01.apname, CA01.CA0100, CA01.CA0101, CA01.CA0102 into
Ïà¹ØÎÊ´ð£º
ÎÊÌâÊÇÕâÑùµÄ£¬ Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬ ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬ ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½ ......
Java code: int startPos=pagesize*(pageNo-1);//pagesize±íʾÿҳÏÔʾÌõÊý pageNo±íʾҳÊý Statement stmt = con.createStatement(); String sql="pdate not in (select top "+startPos+&quo ......
mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ ±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£© ûÓС£ ³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£ ½èÖúÆäËûÓïÑÔ Ä¿Ç°µÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£
......
ÈçÌâ Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£ ÄĸöÐÐÒµ£¿ ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨ ×îºó»¹µÃ×Ô¼ºÕû ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ C#+SQL ¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾ ʲôÐÐÒµ°¡.... µ½51aspx.co ......
ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿ ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯ ÇëÎÊÈçºÎд£¿ SQL code: update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*' UPdateÒ»Ï ......