Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

Çósql²éѯÓï¾ä

±í Category

itemId    itemName
--------------------------
100        A
101        B
102        C

±í Area

areaId      areaName
--------------------------
100      ......

SQL¶à±íǶÌ×

a£º±í

×Ö¶Î id  name
      1    Àî
      2    Íõ
      3    ÕÅ

b£º±í

×Ö¶Î p_id  file      id
      a1    aaaa      1
  ......

sql µ¥Ôª¸ñ Ö»¶Á

ÈçºÎÈ¡ÏûsqlÖе¥Ôª¸ñÖ»¶ÁÊôÐÔ
£¿Ã×Ã÷°×

ÒýÓÃ
ÈçºÎÈ¡ÏûsqlÖе¥Ôª¸ñÖ»¶ÁÊôÐÔ
Ī·ÇlzÒªÐ޸IJéѯºóµÄ½á¹û?????
û¸ã¶®

ÕâÊÇǰ̨³ÌÐòµÄDATAGRIDVIEWÖаÉ,
ÓиöREADONLYÊôÐÔ

?

ÎÒµÄÒâ˼ÊÇ˵sqlÖеıíÀÓÐÒ»ÁÐÊý¾ÝÊÇÉèÖÃÖ»¶ÁÊôÐԵģ¬ÎÒÏë°Ñ¸ÃÁеÄÊý¾ÝÉèÖÃΪ¿É±à¼­µÄ£¬Ë­ÄܸæËßÎÒ£¬Ð»Ð»

2000µÄÆóÒµ¹ÜÀíÆ÷Àï´ò ......

sqlÓï¾ä Çó´í£¡

select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales='"&session("gwid")&"'£©

±¨´í£ºËµ¡°£©¡±¸½½üÓÐÓï·¨´íÎó£¡
²»ÖªµÀ´íÔÚÄÄÀïÁË!


Èç¹û°Ñ'"&session("gwid")&"'  Ö± ......

Éú³É²ÎÊýSQL . ˳±ãÉ¢·Ö.

×î½üÓÃintraWeb,  ºÜ¶à·½Ê½ÒªÓô«²Î·½Ê½.¸ÕûÊÂ,дÁËÒ»¸öÍæ.  Ï£ÍûÓÐÓÃ.  ˳±ãÉ¢·Ö

SQL code:

--select * from KcbWebRegMast
execute PR_GetParaSql 'KcbWebRegMast'
if Exists (select 1 from sysobjects where xtype = 'P' And name = 'PR_GetParaSql')
drop procedure dbo.PR_GetParaSq ......

SQLʱ¼ä²éѯÎÊÌâ

(case when convert(varchar(16),ʱ¼ä×Ö¶Î,120) between convert(varchar(10),ʱ¼ä×Ö¶Î,120)+' 00:00' and convert(varchar(10),ʱ¼ä×Ö¶Î,120)+' 04:59' then convert(varchar(10),ʱ¼ä×Ö¶Î-1,120)
"else convert(varchar(10),vdatetime2,120) end) as ʱ¼ä¶Î

ÏÖÔÚ¿ÉÒÔʵÏÖ£¬±ÈÈç×òÌì5µãµ½Ã ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [245] [246] [247] [248] 249 [250] [251] [252] [253] [254]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ