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

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


Ïà¹ØÎÊ´ð£º

ÎÊÌ⣺ͨ¹ýsql ö¾Ùsqlserver ÉϽ¨Á¢µÄÁ´½Ó·þÎñÆ÷Áбí

ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½ ......

jspÖÐSqlServerµÄ·ÖÒ³ÎÊÌâ

Java code:
int startPos=pagesize*(pageNo-1);//pagesize±íʾÿҳÏÔʾÌõÊý pageNo±íʾҳÊý
Statement stmt = con.createStatement();
String sql="pdate not in (select top "+startPos+&quo ......

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

ÇóÒ»ÐÐÒµÍøÔ´Âë(C#+sqlserver)

ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾

ʲôÐÐÒµ°¡....

µ½51aspx.co ......

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¶¼¼ÓÉÏͬһ¸öÖµ£¿

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿

ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯

ÇëÎÊÈçºÎд£¿
SQL code:
update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*'

UPdateÒ»Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ