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

¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨

  
  ¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨    
  1   :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ    
   
  eg:       Select   *   from   tableName    
                    Exec('select   *   from   tableName')    
                    Exec   sp_executesql   N'select   *   from   tableName'         --   Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN    
   
  2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL    
   
  eg:        
  declare   @fname   varchar(20)    
  set   @fname   =   'FiledName'    
  Select   @fname   from   tableName                             --   ´íÎó,²»»áÌáʾ´íÎ󣬵«½á¹ûΪ¹Ì¶¨ÖµFiledName,²¢·ÇËùÒª¡£    
  Exec('select   '   +   @fname   +   '   from   tableName')           --   Çë×¢Òâ   ¼ÓºÅǰºóµÄ   µ¥ÒýºÅµÄ±ßÉϼӿոñ    
   
  µ±È»½«×Ö·û´®¸Ä³É±äÁ¿µÄÐÎʽҲ¿É    
  declare   @fname   varchar(20)    
  set   @fname   =   'FiledName'   --ÉèÖÃ×Ö¶ÎÃû    
   
  declare   @s   varchar(1000)    
  set   @s   =   'select   '   +   @fname   +   '   from   tableName'    
  Exec(@s)                                 --   ³É¹¦    
  exec   sp_executesql   @s       --   ´


Ïà¹ØÎĵµ£º

³¹µ×Çå³ýSQL SERVERÊý¾Ý¿â

ÔÚ¸ø¸÷ºÏ×÷ѧУ°²×°Ó¦ÓÃϵͳ¹ý³ÌÖУ¬·¢ÏÖѧУÀïµÄSQL SERVER 2000Êý¾Ý¿âËð»µÁË֨װºó¶¼·¢ÉúÁËͬÑùµÄÎÊÌ⣬ÄǾÍÊǰ²×°SQL SERVERÊý¾Ý¿â²»³É¹¦¡£Ô­Òò£º¼´Ê¹Äãͨ¹ý¿ØÖÆÃæ°åÀïµÄ“Ìí¼Ó/ɾ³ý³ÌÐò” Õý³£µÄÐ¶ÔØSQL SERVERÊý¾Ý¿â£¬µ«ÊÇ£¬SQL SERVER»¹ÊÇûÓÐÍêÈ«Ð¶ÔØ¸É¾»£¬»¹ÐèÒªÊÖ¹¤½øÐÐһЩ²Ù×÷¡£Òò´ËÖØÐ°²×°²»³É¹¦£¬º ......

SQL Êý¾Ý¿â¿ª·¢Ò»Ð©¾«µäµÄ´úÂë

1.°´ÐÕÊϱʻ­ÅÅÐò: Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.Êý¾Ý¿â¼ÓÃÜ: select encrypt('ԭʼÃÜÂë') select pwdencrypt('ԭʼÃÜÂë') select pwdcompare('ԭʼÃÜÂë','¼ÓÃܺóÃÜÂë') = 1--Ïàͬ£»·ñÔò²»Ïàͬ
3.È¡»Ø±íÖÐ×Ö¶Î: declare @list varchar(1000),@sql nvarchar(1000)&n ......

SQL Server CONVERT() º¯Êý


Ô­Îijö´¦£ºhttp://www.dingos.cn/index.php?topic=1874.0
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊǰÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_conv ......

Orcale µÄSQL Óï¾äÈ¡µÃϵͳµ±Ç°Ê±¼äÓãºsysdate

Orcale µÄSQL Óï¾äÈ¡µÃϵͳµ±Ç°Ê±¼äÓãºsysdate
    µ±ÐèÒªÔÚϵͳµ±Ç°ÈÕÆÚÉϼõÈ¥Ò»Ììʱ¿ÉÒÔÓà  sysdate-1
     ¸½£ºµ±Ö»¶ÔÒ»¶¨ÊýÁ¿µÄ¼Ç¼¸ÐÐËȤʱ¿ÉÒÔÈç rownum<100
select * from SLYC_CUSTINFO_T where indbtime>sysdate-1 and OFFICE_CODE='46' and rownum<1 ......

SQL »ñÈ¡ÁÐÃû ÀûÓÃϵͳ±í

SELECT sysobjects.name,syscolumns.name
from  sysobjects,syscolumns
WHERE(sysobjects.id=syscolumns.id)
select col_name(OBJECT_ID(£§staff£§),17)
select name
from syscolumns
where id=object_id(£§ÄãµÄ±íÃû£§); ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ