sqlserverµÄOLE¶ÔÏó´´½¨£¬ÕýÔò±í´ïʽÓëÖ»´¦Àí255Ìõ
ÎÒдÁËÒ»¸öSqlServerµÃ±êÁ¿Öµº¯ÊýFUNCTION [dbo].[RegFind]£¬À´´¦Àí±íÖеÄÊý×Ö´®£¬»ñÈ¡Ö¸¶¨¸ñʽµÄÊý×Ö´®¡£
ÎÊÌ⣬[dbo].[RegFind]ÿ´ÎÖ»´¦Àí255Ìõ£¬È»ºó¾Í´¦Àí³ÉnullÖµ£¬ÖØÆôSqlServerºó£¬ÔÙ´¦Àí255Ìõ£¬ºóÃæÓÖÊÇnull£¬
º¦µÄÎÒ£¬Ö»ÄÜÿ´Î255ÌõµÄ·ÖÅú´¦Àí£¬Ò»´Î´ÎµÄÖØÆôSqlServer£¬µ«ÏÖÔÚÓÖ60¶àÍòÌõ¼Ç¼µÄ±íÒª´¦Àí£¬ÃüûÁË£¬¾È¾ÈÎÒ°ÉÐÖµÜÃÇ£¡£¡
¸Ð¾õºÃÏñºÍOLE¶ÔÏóµÄÄÚ´æÓйØ
º¯ÊýÈçÏ£º
ALTER FUNCTION [dbo].[RegFind]
(
@source varchar(5000), --ÐèҪƥÅäµÄÔ´×Ö·û´®
@regexp varchar(1000), --ÕýÔò±í´ïʽ
@ignorecase bit = 0 --ÊÇ·ñÇø·Ö´óСд£¬Ä¬ÈÏΪfalse
)
RETURNS varchar(5000) --·µ»Ø½á¹û0-false£¬1-true
AS
BEGIN
--0£¨³É¹¦£©»ò·ÇÁãÊý×Ö£¨Ê§°Ü£©£¬ÊÇÓÉ OLE ×Ô¶¯»¯¶ÔÏó·µ»ØµÄ HRESULT µÄÕûÊýÖµ¡£
DECLARE @hr integer
--ÓÃÓÚ±£´æ·µ»ØµÄ¶ÔÏóÁîÅÆ£¬ÒÔ±ãÖ®ºó¶Ô¸Ã¶ÔÏó½øÐвÙ×÷
DECLARE @objRegExp integer
DECLARE @objMatches integer
DECLARE @objMatch integer
DECLARE @count integer
--±£´æ½á¹û
DECLARE @results integer
DECLARE @resValue varchar(5000)
/*
´´½¨ OLE ¶ÔÏóʵÀý,Ö»ÓÐ sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±²ÅÄÜÖ´ÐÐ sp_OACreate,²¢È·¶¨»úÆ÷ÖÐÓÐVBScript.RegExpÀà¿â
*/
EXEC @hr = sp_OACreate 'VBScript.RegExp', @objRegExp OUTPUT
IF @hr <> 0 BEGIN
SET @results = 0
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£
ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿
L@_@K
SQL code:
SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY]
°´Ê±¼äÅÅÐò
»ò
guid²»Òª×Ô¶¯Éú³É
......
ÇëÓùýµÄÅóÓѸæ֪ϣ¬Ð»Ð»£¡
ÃÀµÄÄã,ÄÇÍæÒâÖ»ÄÜ×°×°ULTRAEDIT
ÄãÊÔ¹ý£¿È·Êµ²»ÐУ¿
¸çÃÇ ÄãÓÃ586ÅÜÅÜ WIN vista ÊÔÊÔ
ûÄÇôÑÏÖØ£¬ÎÞ·ÇÊÇËÙ¶ÈÂýµã¶øÒÑ£¬¶ÔÓÚvs2008À´Ëµ£¬Äڴ滹ÊǸö¸üÖØÒªµÄÒòËØ¡£
......
ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ
ÓÃList²»ÐÐÂð£¿
ÓÃlist
Ò³ÃæÓà <c:forEach& ......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......