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

Sql Êý¾Ýµ¼³öµ½XMl Óë ´ÓXMLµ¼Èëµ½Êý¾Ý¿â

1¡¢µ¼³öµ½XMl select * from Brand  for xml auto ,root('Brands')
<Brands>
  <Brand BrandID="E584596D-4D66-4F2F-B6F7-71C3BEB4CA21" Name="inganico" />
  <Brand BrandID="19B04451-DDC4-4CDF-BE30-CB4E703B27DA" Name="°²¸¶´ï" />
  <Brand BrandID="3C6C8E12-7C4A-4F19-B491-4C0A64A48303" Name="°²ÖÇ" />
  <Brand BrandID="BF6C361A-8993-4660-A89D-EB32CCC9CE49" Name="°Ù¸»" />
  <Brand BrandID="8E7FE420-3AE3-4017-80AB-B53CA29C80CA" Name="º£²©Í¨" />
  <Brand BrandID="505C5565-08C5-4EF5-9316-55CA76C1E9F3" Name="»Ý¶û·á" />
  <Brand BrandID="E5BA2A72-B1D1-457A-9AFD-A9D9B336E7C0" Name="ÀûÆÕÃÅ" />
  <Brand BrandID="1982A195-5263-45CC-B872-96F3C145FCCD" Name="ÁªµÏ" />
  <Brand BrandID="E460CDA6-4A83-4C62-B049-3B980516AD79" Name="Èð°Ø" />
  <Brand BrandID="06BACF99-BB7E-447C-B021-CD8C3FFAE85A" Name="Èø»ùÄ·" />
  <Brand BrandID="165510D9-342D-4402-882D-0A00DBFDAAE3" Name="дó½" />
  <Brand BrandID="2FA88654-2311-4C51-85B1-A39077C34C6D" Name="йú¶¼" />
</Brands>
2¡¢½«ÉϱßXMLÄÚÈݵ¼»Ø Êý¾Ý¿â
CreatePROCEDURE [dbo].[P_BrandSynchronization]
@xmlDocument NVARCHAR (MAX)
AS
BEGIN
 
 SET NOCOUNT ON;
 DECLARE @docHandle int
 set @xmlDocument='<Brands>'+@xmlDocument+'</Brands>'
 EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument
 declare   @BrandID   uniqueidentifier
 declare   @Name   varchar(16)  ,  @message varchar(500)
 
 
 declare mycursor cursor for (SELECT   *  from   OPENXML   (@docHandle,'/Brands/Brand',1)  
 WITH  (
    BrandID   uniqueidentifier,
    Name   varchar(16)
    ))
 open mycursor
 FETCH NEXT from mycursor INTO @BrandID,@Name
 while(@@FETCH_S


Ïà¹ØÎĵµ£º

Ext.data.Store ¶ÁÈ¡XMLÊôÐÔÖµ


data.xml
<?xml version="1.0" encoding="UTF-8"?>
<Items>
<Item ASIN="0446355453"
Author="Sidney Sheldon"
Manufacturer="Warner Books"
ProductGroup="Book"
Title="Master of the Game"/>

<Item ASIN=" ......

SQL Server¡¢OracleºÍMySQLÖвé³öֵΪNULLµÄÌæ»»

SOURCE: CLICK HERE
±¾ÎĽ²ÊöSQL Server¡¢Oracle¡¢MySQL²é³öֵΪNULLµÄÌæ»»¡£
ÔÚSQL Server Oracle MySQLµ±Êý¾Ý¿âÖвé³öijֵΪNULLÔõô°ì?
1¡¢MSSQL: ISNULL()
Óï·¨
ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
re ......

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

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

SQL Collation

     ÎÄÕÂÓÉÀ´£º ×î½üÐèÒª×öÕâÑùµÄ²âÊÔ:Install the products on machine which case-insensitive SQL installed.
Ëùνcase-insensitive SQL installed¡¡Ö¸ÔÚÊý¾Ý¿â°²×°Ê±Ñ¡ÔñÅÅÐò¹æÔòʱ¡¡ÐèҪѡÔñ´óÐ¡Ð´Çø±ðµÄ¹æÔò¡£
 
¡¡¡¡ÅÅÐò¹æÔò¼ò½é£º
¡¡¡¡¡¡¡¡MSÊÇÕâÑùÃèÊöµÄ£º"ÔÚ  Micr ......

SQL SERVER 2005ÎÞ·¨Ô¶³ÌÁ¬½ÓµÄÎÊÌâ

Á¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü (Microsoft SQL Server£¬´íÎó: 10060)
×ʼÄãµÃÈ·¶¨¿Í»§¶ËÊÇ·ñÄÜpingͨ·þÎñÆ÷¶ËµÄipµØÖ·£¬Èç¹û²»ÄÜÔòÇëÐ޸ķþÎñÆ÷¶ËµÄ·À»ðǽµÄÏàÓ¦¹æÔò£¬Ê¹µÃ¿Í»§¶ËÄܹ»pingÈ룬Ȼºó¾Í¿ªÊ¼½øÐÐÏÂÃæµÄ²½Öè¡£
²½Öè1.
´ò¿ªSQL Server Configur ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ