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

sqlÓï¾ä Çó½Ì

±íA ÄÚ ÓÐid ºÍ name

Ï£Íû¸ù¾ÝA±íµÄname½øÐвéѯ,µ«ÊÇname¿ÉÄÜ»áÖØ¸´,ËùÒÔÐèÒªÅжÏ.

ÓÐÒ»¸ösqlº¯Êý f ,ËüµÄ²ÎÊýÊÇA±íµÄid×Ö¶Î,·µ»ØÒ»¸öÖµ.

ÎÒÏ£Íû×îºóµÃµ½Ò»¸ö±í,°üº¬id name ºÍ[×îºóº¯Êýf·µ»ØµÄÕâ¸öÖµ]cid

±ÈÈç:
id  name    cid
1    xy      c

2    xy      d

3    xy      e


ÕâÑù¿ÉÒÔ¸ù¾Ýcid ºÍname ×÷ΪÁªºÏÖ÷¼ü È·¶¨Î¨Ò»Êý¾Ý,Çó½Ì!
select *,newid() from A

ÒýÓÃ
select *,newid() from A

¿ÉÄÜÎÒû˵Çå³þ,Õâ¸öº¯Êý[f]ÊÇ×Ô¼ºÐ´µÄ,ÊǸù¾ÝA±íÄÚµÄid»ñÈ¡ÆäËû±íÄڵĶÔÓ¦Öµ.


¶÷ ¶÷ ... ллÁË T T Õâô¼òµ¥...555555 ¹âÍù¸´ÔÓÉÏÏëÁË.¿´À´ÊÇд´úÂëд±¿ÁË....

ÒýÓÃ
select *,f(id) from A

Ó¦¸ÃÊÇÕâÑùµÄ


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

sql Óï¾äÓÅ»¯ ÎÊÌ⣿ ÇóÖú£¡

SELECT ×Ö¶Î1
  from ±í  WHERE (...) AND ×Ö¶Î1=function()

×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1
  function ·µ»Ø 0 »òÕß -1

ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË  Çë¸ßÊÖ°ïæ
¶¨£¡


ÎÒд³ ......

vbÖ´ÐÐaccess sqlÓï¾ä¹ÖÎÊÌâ

SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";

ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......

Microsoft SQL Server 2005 JDBC Driver °æ±¾ÎÊÌâ

Microsoft SQL Server 2005 JDBC Driver  Õâ¸öÇý¶¯´ó¼ÒÓÐÓùýÂð£¿ÓÃʲô°æ±¾ºÅ¡£Î¢Èí¹ÙÍøÓÐ1.1µÄ»¹ÓÐ2.0µÄ£¬ÎÒÓõÄIDEÊÇJBuilder9
ÏÖÔÚÓÃ2.0µÄ°É£¬È¥Î¢ÈíÍøÕ¾ÏÂÔØ¼´¿É¡£Á¬½Ó×Ö·û´®ºÍÒÔǰÉÔÓв»Í¬£¬¿ÉÒÔËÑÒ»ÏÂÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ