aspÁ´½ÓsqlÊý¾Ý¿â ´úÂë
dim conn,connstr
Set conn = Server.CreateObject("ADODB.Connection")'´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó¶ÔÏóconn£¬·½±ãºóÃæµ÷ÓÃ
connstr="Provider=SQLOLEDB;Data Source=(local);Initial Catalog=111;User ID=sa;Password=1234;" '´´½¨Ò»¸öÊý¾Ý¿âµÄrecordset¶ÔÏ󣬷½±ãÒÔºóµ÷ÓÃ
conn.Open connstr'´ò¿ªÊý¾Ý¿â
Ïà¹ØÎĵµ£º
declare @XML XML
SET @XML='<root>
<OLDVALUE>
<H_Action id="1130">030</H_Action>
<D_Action>030</D_Action>
<OrderCompany>00220</OrderCompany>
<OrderNumber>10004035</OrderNumber> ......
ÒÔϵļ¼ÇÉÖ»Õë¶ÔPL/SQL Developer 6ÒÔÉϰ汾£¬°æ±¾5Ö»ÓÐÆäÖеIJ¿·ÖÌØÐÔ¡£
1£¬ÓÒ¼ü²Ëµ¥
ÔÚPL/SQL Developer£¨ÏÂÃæ¼ò³ÆPLD£©ÖеÄÿһ¸öÎı¾±à¼´°¿Ú£¬ÈçSQL Window£¬Command WindowºÍPorgram Window£¬ÓÒ¼üµã»÷ij¸ö¶ÔÏóÃû³Æ£¬»áµ¯³öÒ»¸ö°üº¬²Ù×÷¶ÔÏóÃüÁîµÄ²Ëµ¥£¬ÎÒÃÇÕâÀï³ÆÖ®ÎªÓÒ¼ü²Ëµ¥¡£ÈçÏÂͼ£º
¶ÔÏóÀàÐÍ¿ÉÒÔÊÇ±í£¬ÊÓͼ£ ......
/*------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-16 14:30:23
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
&nb ......
ºÜÉÙÓÃjoin£¬Õâ´Îѧѧ£¬²¢±¸ÍüÁ½ÆªÎÄÕ£¡
ת×Ô£ºhttp://hcx-2008.javaeye.com/blog/285661
Á¬½Ó²éѯ
ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ ......