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

sql ·Ö¸î×Ö·û´® Êä³ö

ʾÀý£º
´«Èë¶à¸öEmailµØÖ·,ͨ¹ýÿ¸öEmailµØÖ·¼äµÄ','·Ö¸ô·û£¬½«¸÷EmailµØÖ··Ö¿ª¡£
SELECT * from dbo.uf_Split('aa@aa.com,bb@bb.com,cc@cc.com,dd@dd.com',',');
²éѯ½á¹û£º
subid      autoid
aa@aa.com 1
bb@bb.com 2
cc@cc.com 3
dd@dd.com 4
ÏÂÃæÊÇ[uf_Split]·½·¨µÄ¾ßÌåʵÏÖ£º
CREATE   FUNCTION [dbo].[uf_Split](@str VARCHAR(max),@splitchar CHAR(1))      
RETURNS  @t TABLE(subid VARCHAR(1000),autoid INT) AS       
/*      
subject:splitº¯Êý(ĿǰֻÄܶԵ¥¸ö×Ö·û½øÐзָ²»ÄÜÒÔ´Ê×鷽ʽ·Ö¸î)      
author:kq zhou     
create date:2009-4-1      
*/      
BEGIN      
      
DECLARE @substr VARCHAR(max)      
SET @substr=@str      
DECLARE @i INT,@j INT      
SET @j=LEN(REPLACE(@str,@splitchar,REPLICATE(@splitchar,2)))-LEN(@str)--»ñÈ¡·Ö¸î·û¸öÊý      
IF @j=0      
BEGIN      
  INSERT INTO @t VALUES (@substr,1) --ûÓзָî·ûÔò²åÈëÕû¸ö×Ö´®       
END      
ELSE      
BEGIN      
 SET @i=0      
 DECLARE @m int      
 WHILE @i<=@j      
 BEGIN      
   IF(@i<@j)      
   BEGIN      
    SET @m=CHARINDEX(@splitchar,@substr)-1 --»ñÈ¡·Ö¸î·ûµÄǰһλÖà      
    INSERT INTO @t VALUES(LEFT(@substr,@m),@i+1)       
    SET @substr=RIGHT(@substr,LEN(@substr)-(@m+1)) --È¥³ýÒÑ»ñÈ¡µÄ·Ö¸î´®£¬µÃµ½»¹ÐèÒª¼ÌÐø·Ö¸îµÄ×Ö·û´®      
   END      
  ELSE      
   BEGIN      
     INSERT INTO @t VALUES(@substr,@i+1)--¶Ô×îºóÒ»¸ö±»·Ö¸î


Ïà¹ØÎĵµ£º

sql server

exec sp_spaceused [[@objname=]'objname'][,[@updateusage=]'updateusage']
¼ì²éÊý¾Ý¿â¿Õ¼ä´óС
 dbcc   showfilestats
ͳ¼ÆÊý¾ÝÎļþµÄʹÓÃÇé¿ö
 dbcc   showcontig
¼ì²éÊý¾Ý¿â¿Ø¼þ·ÖÅäÇé¿ö
 dbcc   sqlperf(logspace)
²é¿´ÈÕÖ¾ÎļþµÄʹÓÃÇé¿ö ......

PHPÅäÖÃSQL Server 2008

1¡¢µ½Î¢Èí¹Ù·½È¥ÏÂÔØÐµÄÇý¶¯£¬ÏÂÔØµØÖ·ÈçÏ£º
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9
 
¡¡¡¡¹Ù·½ÎĵµÓÐÃèÊö£º
¡¡¡¡Refer to the documentation that is installed with the driver for a description of the new features in this ......

vfp/(asp/vfpdll/Sql)

ÒÔÏÂÊÇ·¢ÔÚ÷×ÓÂÛ̳µÄÌù×Ó£¬×ª·¢¹ýÀ´£¬Ï£Íû¸øÓõÃ×ŵĺüÓѲο¼¡£
ÎҵijÌÐòÒÔǰһֱÊÇÓû¨Éú¿Ç°ó¶¨IPʵÏÖµÄÔ¶³Ì£¬ÓÉÓÚ¿Í»§·þÎñÆ÷ºÍ¿Í»§¶Ë¶¼ÊÇͨ¹ý¿í´øÉÏÍø£¬Ò»°ãµÄ²Ù×÷£¨¿ª½ø»õµ¥¡¢ÏúÊÛµ¥µÈ£©ËÙ¶ÈÒ²»¹²»´í£¬µ«ÊÇÔÚÔ¶³Ì¿Í»§¶ËÐÞ¸ÄÉÌÆ·×ÊÁÏ£¨10000¶àÌõ¼Ç¼£©¡¢²éѯһ¶ÎʱÆÚµÄ½øÏú´æÁ÷Ë®£¨Ò»ÖÜ5000ÌõÒÔÉÏ£©µÈÉæ¼°µ½È¡¼Ç¼Á¿´óµ ......

SQLÐÐתÁеĶ¯Ì¬¹¹Ôì·½·¨

SQLÐÐתÁеĶ¯Ì¬¹¹Ôì·½·¨
/*¼ÙÉèÓÐÕÅѧÉú³É¼¨±í(tb)ÈçÏÂ:
ÐÕÃû ¿Î³Ì ·ÖÊý
ÕÅÈý ÓïÎÄ 74
ÕÅÈý Êýѧ 83
ÕÅÈý ÎïÀí 93
ÀîËÄ ÓïÎÄ 74
ÀîËÄ Êýѧ 84
ÀîËÄ ÎïÀí 94
Ïë±ä³É(µÃµ½ÈçϽá¹û)£º
ÐÕÃû ÓïÎÄ Êýѧ ÎïÀí
---- ---- ---- ----
ÀîËÄ 74 84 94
ÕÅÈý 74 83 93
-------------------
*/
create t ......

SQL ²é詢²»區·Ö´óС寫

SQL ²é詢²»區·Ö´óС寫
2007Äê04ÔÂ19ÈÕ ÐÇÆÚËÄ 15:27
Õý³£ÓÃÕâ¸ö·½·¨¾Í¸ø達µ½Ð§¹ûÁË¡£select * from
pl_account     where UPPER(fname) like 'PE%'
¸½¼Ó£º
ÔÚsql2000ºÍ7.0µÄ²éѯÓï¾äÖÐ,Çø·Ö´óдµÄ²éѯ·½·¨
--sql2000,¾ÍÓÃÏÂÃæµÄ·½·¨.
--¾ÍÊÇÔÚ×Ö¶ÎÃûºó¼Ó collate Chi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ