SQL Server Compact 3.5 SP2ÒѾ·¢²¼
Ëæ×ÅVisual Studio 2010µÄ·¢²¼£¬Microsoft SQL Server Compact 3.5Ò²Éý¼¶ÎªMicrosoft
SQL Server Compact SP2¡£
ÏÂÔØµØÖ·ÈçÏ£º
SQL
Server Compact 3.5 SP2 for Windows mobile devices (all platforms &
processors)
SQL
Server Compact 3.5 SP2 for Windows desktop (32-bit and 64-bit)
SQL
Server Compact 3.5 SP2 Server Tools (32-bit and 64-bit)
SQL Server Compact
3.5 SP2 Books Online
(¸ÃÁ´½ÓÔÚÏÂÖܲŻáÉúЧ)
SQL Server Compact 3.5 SP2
Samples
Refer to: http://www.wpmind.com/dev/2010/04/15/sql-ce-3-5-sp2-is-released.html
Ïà¹ØÎĵµ£º
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> ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ìæ»»ÎªÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......
SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
ÓÉ lwgboy @ MoFun.CC, ÔÚ 08-9-12 ÏÂÎç5:00
±ê¼Ç: linkserver, oracle, sqlserver, Á´½Ó·þÎñÆ÷
SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
SQL Server 2005 ÒìÀàÊý¾ÝÔ´(ORACLE10G)Á´½Ó·þÎñÆ÷µÄ½¨Á¢
±¾ÎļòÊöSqlServer 2005 Á´½Óµ½ Oracle10g ·þÎñÆ÷µÄ¹ý³Ì¼°»ù ......