SQL ÖÐÎÄתƴÒô
--º¯ÊýÈçÏ£º
/*
CREATE FUNCTION dbo.fnpbGetPYFirstLetter
(
@str NVARCHAR(4000)
)
RETURNS NVARCHAR(4000)
--WITH ENCRYPTION
AS
BEGIN
DECLARE @WORD NCHAR(1),@PY NVARCHAR(4000)
SET @PY=''
WHILE LEN(@STR)>0
BEGIN
SET @WORD=LEFT(@STR,1)
--Èç¹û·Çºº×Ö×Ö·û£¬·µ»ØÔ×Ö·û
SET @PY=@PY+(CASE WHEN UNICODE(@WORD) BETWEEN 19968 AND 19968+20901
THEN (
SELECT TOP 1 PY
from
(
SELECT 'A' AS PY,N'驁' AS WORD
UNION ALL SELECT 'B',N'²¾'
UNION ALL SELECT 'C',N'錯'
UNION ALL SELECT 'D',N'鵽'
UNION ALL SELECT 'E',N'樲'
UNION ALL SELECT 'F',N'鰒'
UNION ALL SELECT 'G',N'腂'
UNION ALL SELECT 'H',N'夻'
UNION ALL SELECT 'J',N'攈'
UNION ALL SELECT 'K',N'穒'
UNION ALL SELECT 'L',N'鱳'
UNION ALL SELECT 'M',N'旀'
UNION ALL SELECT 'N',N'桛'
UNION ALL SELECT 'O',N'漚'
UNION ALL SELECT 'P',N'ÆØ'
UNION ALL SELECT 'Q',N'囕'
UNION ALL SELECT 'R',N'鶸'
UNION ALL SELECT 'S',N'蜶'
UNION ALL SELECT 'T',N'籜'
UNION ALL SELECT 'W',N'鶩'
UNION ALL SELECT 'X',N'鑂'
UNION ALL SELECT 'Y',N'韻'
UNION ALL SELECT 'Z',N'咗'
) T
WHERE WORD>=@WORD COLLATE CHINESE_PRC_CS_AS_KS_WS
ORDER BY PY ASC
)
ELSE @WORD
END)
SET @STR=RIGHT(@STR,LEN(@STR)-1)
END
RETURN @PY
END
*/
µ÷ÓÃʾÀý£º
--City PinYin
select dbo.fnpbGetPYFirstLetter('ÉϺ£ÊÐ')
Result: "SHS"
Ïà¹ØÎĵµ£º
ASPµ÷Óô洢¹ý³ÌµÄ·½·¨£º
---- ¡¡¡¡µ÷Óô洢¹ý³ÌµÄ·½·¨ÐèҪʹÓÃADOµÄCommand¶ÔÏó¡£Command¶ÔÏóÊǶÔÒ»¸öÊý¾ÝÔ´ÔËÐÐÌض¨ÃüÁîµÄ¶¨Ò壨ÀýÈ磬һ¸öSQL²éѯ»òÒ»¸öSQL´æ´¢¹ý³Ì£©¡£ÏÂÃæÒÔMS SQL SERVER6.5Ϊºǫ́Êý¾Ý¿â£¬½éÉÜASPµ÷Óô洢¹ý³ÌµÄ·½·¨¡£
---- ¡ ......
<%
SQL1 = "update table1 set a=b where id=1"
Conn.ExeCute SQL1
SQL2 = "update table2 set a=b where id=2"
Conn.ExeCute SQL2
SQL3 = "update table3 set a=b where id=3"
Conn.ExeCute SQL3
%>
&nb ......
sqlµ¼³öÊý¾Ý¿âʱ±¨ "µÇ½ xxx ʧ°Ü",ÎÞ·¨Íê³É
µ¼³öÊý¾Ý¿âʱʧ°Ü,µã»÷ÏëÏëÐÅϢʱÏÔʾ:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]µÇ½ xxx ʧ°Ü
ÒòÊý¾Ý¿âÊÇÖ±½ÓÒûÓÃËûÈ˵Ä,Ìí¼Ó¶ø³É,Òò´Ë²»È·¶¨ xxx µ½µ×ÊÇʲô,Ö»ºÃ½«Ïà¹ØÏîÒÀ´Îɾ³ý
½«Í¬Ãû xxx ±íɾ³ý,ɾ³ýÏà¹ØÊÓͼ,ÖØÊÔ,²»ÐÐ.
ɾ³ýÈ«²¿ÊÓͼ,²»ÐÐ.
żȻ ......
SQL Óï·¨Ìصã:
1 ÿ¸öÓï¾äÒÔ;½áÊø£¬ÖмäÓÃ()°üº¬£¬,¼ä¸ô¡£
2 ¶Ô±äÁ¿ºÍ³£Á¿µÈÐèÒªÓÃ()°üº¬¡£
3 ¹Ø¼ü×Ö´óд£¬±äÁ¿ÃûÊ×´óд×ÖĸÓñíÃû±íÕ÷£¬È»ºóÓÃСд±íÕ÷ÊôÐÔ
»ù±¾Óï¾ä:
DESC ±íÃû
²é¿´±íÏêϸÊôÐÔ
½¨±í: CREATE TABLE ±íÃû
( ÊôÐÔÃû ÀàÐÍ(Ô¼Êø) Ö÷¼ü(PRIMARY KEY)
Èç¹ûÊÇÓòΪÖ÷¼ü PRIMARY KEY(ÊôÐÔ.. ......
ÕâƪÎÄÕÂÊÇÐþ»úÒÝʿΪijÉÏÊй«Ë¾µÄERPϵͳµ÷ÓÅËù׫д±¨¸æµÄ²¿·Öժ¼£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú£º
ÏÂÃæ¸ø³öSQLÓÅ»¯¾³£Óöµ½µÄÇéÐΡ£ËüÃÇÊÇÔںܶàÈ˳¤ÆÚ»ýÀ۵ľÑéÉÏ×ܽá³öÀ´µÄ£¬ÕâЩ¶¼ÊÇһЩһ°ãÐԵĽáÂÛ£¬ÔÚʵ¼Ê¹¤×÷ÖУ¬»¹Ó¦µ±¾ßÌåÇé¿ö¾ßÌå·ÖÎö£¬²¢¼ÓÒÔÁé»îÔËÓá£
(1) ÓÃNOT EXISTSÌæ»»NOT IN ½«¸üÏÔÖøµØÌá¸ßЧÂÊ£¬¾ ......