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

´Ó¸÷ÖÖλÖýØÈ¡×Ö·û´®µÄSQLÓï·¨

Öª: ×Ö¶ÎA='F:\photo\Winter Leaves.jpg'  
ÒªÇó:·Ö¶Î½Øȡÿ¶Î×Ö·û[×Ö¶ÎA²»ÄÜΪTEXTÀàÐÍ,·ñÔò±¨´í]
½â¾ö·½·¨:
---½ØÈ¡×Ö·û´®AµÄµÚÒ»¸ö\×ó±ßµÄ×Ö·û´®
select left(A,charindex('/',A)-1)
Êä³ö½á¹û£ºF:
---½ØÈ¡\ÖмäµÄ×Ö·û´®
select  left(stuff(A,1,charindex('/',A),''),charindex('/',stuff(A,1,charindex('/',A),''))-1)
Êä³ö½á¹û£ºphoto
---½ØÈ¡×îºóÒ»¸ö\ºóÃæµÄ×Ö·û´®
select  reverse(left(reverse(A),charindex('/',reverse(A))-1))
Êä³ö½á¹û£ºWinter Leaves.jpg
 
---½ØÈ¡×Ö·û´®AµÄÊ××ÖÄ»
select  STUFF(A,1, 1, '')
Êä³ö½á¹û£º:\photo\Winter Leaves.jpg


Ïà¹ØÎĵµ£º

µÚ10Õ£ºSQLºÍTQuery¶ÔÏó

±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......

ʵÓÃSQL語¾ä

http://blog.csdn.net/fenglibing/archive/2007/10/24/1841537.aspx
1¡¢½«Ò»¸ö±íÖеÄÄÚÈÝ¿½±´µ½ÁíÍâÒ»¸ö±íÖÐ
insert into testT1(a1,b1,c1) select a,b,c from test;
insert into testT select * from test; (Ç°ÌáÊÇ兩個±íµÄ結構ÍêÈ«Ïàͬ)
 
insert into notebook(id,title,content)
se ......

SQL´æ´¢¹ý³Ì²âÊÔ£¨5£©——´ÓT

ÎÊÌâ
      ÈçºÎÈÃT-SQL²âÊÔÌ×¼þ°Ñ²âÊÔÓÃÀý½á¹ûÖ±½ÓдÈëÎı¾Îļþ
Éè¼Æ
      ʹÓÃActiveX¼¼ÊõʵÀý»¯Ò»¸öFileSystemObject¶ÔÏó£¬È»ºóͨ¹ýOpenTextFile()ºÍWriteLine()·½·¨Ö±½Ó°Ñ²âÊÔ½á¹ûдÈëÎļþ¡£
·½°¸
declare @fsoHandle int,@fileID int
exec sp_OACreate 'Scr ......

SQL Server2000ÖÐËÀËø¾­Ñé×ܽá

   ÎÒÃÇÔÚ×öºÜ¶àÏîĿʱ¶¼ÒªÉæ¼°µ½Êý¾Ý¿â£¬ÌرðÊÇһЩ±È½Ï´óÐ͵ÄwebÏîÄ¿£¬¸üÊÇÓнϴóµÄ²¢·¢´¦Àí£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÓпÉÄÜ»á²úÉúËÀËø£¬¶ÔÓÚÊý¾Ý¿âµÄËÀËø£¬Ò»°ãÊý¾Ý¿âϵͳ¶¼»áÓÐÒ»Ì×»úÖÆÈ¥½âËø£¬Ò»°ã²»»áÔì³ÉÊý¾Ý¿âµÄ̱»¾£¬µ«½âËøµÄ¹ý³Ì»áÔì³ÉÊý¾Ý¿âÐÔÄܵļ±ËÙϽµ£¬·´Ó³µ½³ÌÐòÉϾͻáÔì³É³ÌÐòµÄ·´Ó¦ÐÔÄܵÄϽµ£¬²¢ ......

SQL Server ¼¸¸öºÃÓõÄSQLÓï¾ä

SQL Server ¼¸¸öºÃÓõÄSQLÓï¾ä
1¡¢¸´ÖƱí
 select * into desttable from srctable
 ½« srctable ÍêÕûµØ¸´ÖÆÒ»·Ýµ½ desttable ÖУ¬µ±È»ºóÃæÒ²¿ÉÒÔ¼ÓÉÏÌõ¼þÀ´ÏÞ¶¨ÐèÒª¸´ÖƵļǼ
 ÒªÇó£ºdesttable ±ØÐëΪ²»´æÔڵıíÃû¡£
 insert into desttable(column1, column2) select columna, columnb from sr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ