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

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


Ïà¹ØÎĵµ£º

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

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

¾­µäSQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
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 µ¼³öÓû§±íÊý¾Ý×Öµä(×ªÔØ)

-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ìæ»»ÎªÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......

SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷

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 ·þÎñÆ÷µÄ¹ý³Ì¼°»ù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ