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

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


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

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 ......

Ôõô»ñÈ¡sqlserver×îºó²åÈëÐÐÄÚµÄ×ֶΣ¿

Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£

ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿


L@_@K
SQL code:
SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY]

°´Ê±¼äÅÅÐò
»ò
guid²»Òª×Ô¶¯Éú³É
......

Atom N280ÄÜ°²×°²¢Ê¹ÓÃvs.net2008ºÍsqlServerÂð

ÇëÓùýµÄÅóÓѸæ֪ϣ¬Ð»Ð»£¡
ÃÀµÄÄã,ÄÇÍæÒâÖ»ÄÜ×°×°ULTRAEDIT

ÄãÊÔ¹ý£¿È·Êµ²»ÐУ¿

¸çÃÇ  ÄãÓÃ586ÅÜÅÜ WIN vista ÊÔÊÔ

ûÄÇôÑÏÖØ£¬ÎÞ·ÇÊÇËÙ¶ÈÂýµã¶øÒÑ£¬¶ÔÓÚvs2008À´Ëµ£¬Äڴ滹ÊǸö¸üÖØÒªµÄÒòËØ¡£
......

jspÖÐsqlserver2005²éѯµÄ·µ»ØÖµ

ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ­»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ
ÓÃList²»ÐÐÂð£¿

ÓÃlist

Ò³ÃæÓà <c:forEach& ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ