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

Çë½ÌÒ»ÌõsqlÓï¾äµÄд·¨ - .NET¼¼Êõ / ASP.NET

±íA£¬ÁÐ a£¬b£¬c ÀàÐÍ·Ö±ðΪint£¬char£¬char

±íb£¬ÁÐd£¬e£¬ÀàÐÍ·Ö±ðΪchar£¬char

ÏÖÔÚÏëinsert A select ?,d,e from b

  ? ´¦£¬ÏëÈÃËûÖðÌõÔö³¤1

ÈçÓÐ3Ìõ£¬aÔ­ÓÐ3Ìõ

ÔòÐÂÔö¼ÓµÄ¾ÍÊÇ 4£¬d£¬e£»5£¬d£¬e£»6£¬d£¬e

Õâ¸ö£¿´¦µÄÖµÓ¦¸ÃÔõôд£¿

ÁÐa·Ç×ÔÔö³¤Áж¨Òå

²»ÄÜÓÃÓαꡣ¿ÉÒÔÓô洢¹ý³Ì£¬¶àÌõÓï¾ä¡£

Çë½Ì¶®µÄÈË£¬¸ÃÈçºÎд£¿
insert A select (select isnull(count(*),0)+1 from a ),d,e from b


лл¸÷·ÉñÏÉ£¬µã²¦µÄºÃ°¡

UPһϡ£¡£¡£µ«ÊÇÕâÑù»á²»»áЧÂÊÉϵÍÁ˵㣬ÿ²åÈëÒ»Ìõ¾ÍÈ¥²éѯһ´Î×î´óµÄ¡£¡£¡£
¿ÉÒÔÏȰÑb±íÀïÊý¾Ý·ÅÔÚÓαêÀȻºóȡһ´Îa±íÀï×î´óÖµ£¬È»ºó´ÓÓαêÀïȡֵ²åÈëa±íʱ¾Í¿ÉÒÔÖ±½ÓÀÛ¼ÓÁË£¬ÕâÑùÊDz»ÊǺõ㡣¡£¡£
ÒýÓÃ
лл¸÷·ÉñÏÉ£¬µã²¦µÄºÃ°¡


²»ºÃÒâ˼ÒýÓôíÁË¡£¡£¡£Ó¦¸ÃÒýÓᣡ£¡£
ÒýÓÃ
ÒýÓà 1 Â¥ wuyq11 µÄ»Ø¸´:
insert A select (select isnull(count(*),0)+1 from a ),d,e from b


Èç¹ûaÕâ¸öÊÇΨһµÄ»°ÉÏÃæµÄÓï¾ä¿ÉÄÜ»á³öÎÊÌ⣬ÒòΪÈç¹ûɾ³ýÁ˼¸¸öÖµÒÔºóµÃ³öµÄÖµ¾Í¿ÉÄÜÖØ¸´£¬¸öÈ˾õµÃÓ¦¸Ã°Ñcount¸Ä³Émax(a)±È½ÏºÏÀí



Â¥Ö÷˵µÄÊDz»ÄÜÓÃÓαê

insert A(b, c) select d,e from b

ʲô¶¼²»¼Ó¡£

µ÷ÓÃAÊý¾Ýʱ£¬ 

select ROW_NUMBER() OVER (order by a), * from A

ÓÉϵͳ×Ô¶¯ÖØÐ±àºÅ¡£sql2005Ö§³Ö¡£

sybaseÊý¾Ý¿â£¬Óα꼫Ò×ËÀËø£¬ÄþԸЧÂÊÂÔµÍÒ»µãµÄ¡£




Ïà¹ØÎÊ´ð£º

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

ÇóÖú£ºÕÒASP.NETÍøÒ³ÖÆ×÷¸ßÊÖ£¬Óб¨³ê¡£

±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»Æ­ÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......

ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ? - .NET¼¼Êõ / ASP.NET

ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ?
ÕÒ¸öÈ«²Å·­Òë¡£

ÊÖ¶¯È¥Ð´
¸Ð¾õд¹ýaspµÄ£¬À´Ð´asp.net£¬ÉÏÊÖÓ¦¸Ã¿ìµã¡£
¸üÄÜÀí½âasp.netµÄһЩÄÚ²¿¼¼Êõ
asp.net¶¼±»·â×°ÁË

ÎÒÊÇ×ö.NetµÄ£¬¶ÔASPһֱû½Ó´¥µ½£¬ºÜİÉú¡£
¹« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ