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)--¶Ô×îºóÒ»¸ö±»·Ö¸î
Ïà¹ØÎĵµ£º
exec sp_spaceused [[@objname=]'objname'][,[@updateusage=]'updateusage']
¼ì²éÊý¾Ý¿â¿Õ¼ä´óС
dbcc showfilestats
ͳ¼ÆÊý¾ÝÎļþµÄʹÓÃÇé¿ö
dbcc showcontig
¼ì²éÊý¾Ý¿â¿Ø¼þ·ÖÅäÇé¿ö
dbcc sqlperf(logspace)
²é¿´ÈÕÖ¾ÎļþµÄʹÓÃÇé¿ö ......
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 ......
ÒÔÏÂÊÇ·¢ÔÚ÷×ÓÂÛ̳µÄÌù×Ó£¬×ª·¢¹ýÀ´£¬Ï£Íû¸øÓõÃ×ŵĺüÓѲο¼¡£
ÎҵijÌÐòÒÔǰһֱÊÇÓû¨Éú¿Ç°ó¶¨IPʵÏÖµÄÔ¶³Ì£¬ÓÉÓÚ¿Í»§·þÎñÆ÷ºÍ¿Í»§¶Ë¶¼ÊÇͨ¹ý¿í´øÉÏÍø£¬Ò»°ãµÄ²Ù×÷£¨¿ª½ø»õµ¥¡¢ÏúÊÛµ¥µÈ£©ËÙ¶ÈÒ²»¹²»´í£¬µ«ÊÇÔÚÔ¶³Ì¿Í»§¶ËÐÞ¸ÄÉÌÆ·×ÊÁÏ£¨10000¶àÌõ¼Ç¼£©¡¢²éѯһ¶ÎʱÆÚµÄ½øÏú´æÁ÷Ë®£¨Ò»ÖÜ5000ÌõÒÔÉÏ£©µÈÉæ¼°µ½È¡¼Ç¼Á¿´óµ ......
SQLÐÐתÁеĶ¯Ì¬¹¹Ôì·½·¨
/*¼ÙÉèÓÐÕÅѧÉú³É¼¨±í(tb)ÈçÏÂ:
ÐÕÃû ¿Î³Ì ·ÖÊý
ÕÅÈý ÓïÎÄ 74
ÕÅÈý Êýѧ 83
ÕÅÈý ÎïÀí 93
ÀîËÄ ÓïÎÄ 74
ÀîËÄ Êýѧ 84
ÀîËÄ ÎïÀí 94
Ïë±ä³É(µÃµ½ÈçϽá¹û)£º
ÐÕÃû ÓïÎÄ Êýѧ ÎïÀí
---- ---- ---- ----
ÀîËÄ 74 84 94
ÕÅÈý 74 83 93
-------------------
*/
create t ......
SQL ²é詢²»區·Ö´óС寫
2007Äê04ÔÂ19ÈÕ ÐÇÆÚËÄ 15:27
Õý³£ÓÃÕâ¸ö·½·¨¾Í¸ø達µ½Ð§¹ûÁË¡£select * from
pl_account where UPPER(fname) like 'PE%'
¸½¼Ó£º
ÔÚsql2000ºÍ7.0µÄ²éѯÓï¾äÖÐ,Çø·Ö´óдµÄ²éѯ·½·¨
--sql2000,¾ÍÓÃÏÂÃæµÄ·½·¨.
--¾ÍÊÇÔÚ×Ö¶ÎÃûºó¼Ó collate Chi ......