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

ʹÓÃSQL²Ù×÷XML¼òµ¥Ê¾Àý

declare @xml xml
set @xml = '<root/>'
select @xml
declare @value varchar(10)
set @value = 'val1'
set @xml.modify('insert <item value="{sql:variable("@value")}" /> into (/root)[1]')
select @xml
set @value = 'val2'
set @xml.modify('replace value of (/root/item/@value)[1] with "val2"')
select @xml
set @value = 'val3'
set @xml.modify('replace value of (/root/item/@value)[1] with sql:variable("@value")')
select @xml


Ïà¹ØÎĵµ£º

xml ÐÎʽµÄ´æ´¢¹ý³Ì

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[MachiningPayedGetListByCondition]
@CustomerName varchar(50),
@CustomerPhone varchar(50),
@PactNumber varchar(50),
@Ispay bit
as
begin
 set nocount on;
 SELECT
 dp.ID as 'MachiningPayed/@ID',
&nbs ......

Àí½âSQL ServerÖеÄË÷Òý£¨Ò»£©

¶ÔÓںܶàDBAºÍ³ÌÐòÔ±À´Ëµ£¬SQL ServerÖеÄË÷Òý²»ÊÇÒ»¸öİÉúµÄÊÂÎÎÒÃÇÉõÖÁÿÌì¶¼ÔÚʹÓÃËü£¬¶ÔÓÚÄÄЩÇé¿öÏÂÓ¦¸Ã´´½¨Ë÷Òý¶¼ÄÜÒ»Ò»µÄµÀ³ö£¬²»¹ýÓпÉÄÜÎÒÃDz¢Ã»ÓÐ×ÐϸȥÏëËüµÄ¾ßÌåÔ­Àí£¬±¾ÎĽ«¸ù¾ÝÎÒ¶ÔSQL ServerÖеÄË÷ÒýµÄÀí½â×öÒ»¸ö¼òµ¥µÄ×ܽáºÍ¸ÅÊö£¬Ï£Íû¶Ô´ó¼ÒÄÜÓÐËù°ïÖú£¨Ïêϸ¿É²Î¿¼¡¶SQL Server 2005 Implementation an ......

Çå¿ÕSQL ServerÊý¾Ý¿âÖÐËùÓбíÊý¾ÝµÄ·½·¨

Æäʵɾ³ýÊý¾Ý¿âÖÐÊý¾ÝµÄ·½·¨²¢²»¸´ÔÓ£¬ÎªÊ²Ã´ÎÒ»¹Òª¶à´ËÒ»¾ÙÄØ£¬Ò»ÊÇÎÒÕâÀï½éÉܵÄÊÇɾ³ýÊý¾Ý¿âµÄËùÓÐÊý¾Ý£¬ÒòΪÊý¾ÝÖ®¼ä¿ÉÄÜÐγÉÏà»¥Ô¼Êø¹ØÏµ£¬É¾³ý²Ù×÷¿ÉÄÜÏÝÈëËÀÑ­»·£¬¶þÊÇÕâÀïʹÓÃÁË΢ÈíδÕýʽ¹«¿ªµÄsp_MSForEachTable´æ´¢¹ý³Ì¡£
¡¡¡¡Ò²ÐíºÜ¶à¶ÁÕßÅóÓѶ¼¾­Àú¹ýÕâÑùµÄÊÂÇ飺ҪÔÚ¿ª·¢Êý¾Ý¿â»ù´¡ÉÏÇåÀíÒ»¸ö¿Õ¿â£¬µ«ÓÉÓÚ¶ÔÊ ......

fw_student_SqlMap.xml(SQL ºÍVOµÄÓ³ÉäÎļþ)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="fw_student">
<resultMap class="com.sias.Student" id="student">
<result column="name" property="na ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ