²Ù×÷SQL Server MobileÊý¾Ý¿âµÄ³£ÓÃC#´úÂë
window.onerror = function() { return true; };
body {margin:0;overflow:auto;font:normal 14px Verdana;background:#fff;padding:2px 4px 0;}body, p, font, div, li { line-height: 150%;}body, td, th {color:#000000;}.i {width:100%;*width:auto;table-layout:fixed;}pre {white-space: pre-wrap;white-space: -moz-pre-wrap;white-space: -pre-wrap;white-space: -o-pre-wrap;word-wrap: break-word;}a { color: -moz-hyperlinktext !important;text-decoration: -moz-anchor-decoration;}
²Ù×÷SQL Server MobileÊý¾Ý¿âµÄ³£ÓÃC#´úÂë
1. ´´½¨Êý¾Ý¿â
// ´´½¨Êý¾Ý¿â
File.Delete("Test.sdf");
SqlCeEngine engine =
new SqlCeEngine(
"Data
Source='Test.sdf';LCID=1033;Password=\"s$;2'!dS64\";Encrypt=TRUE;");
engine.CreateDatabase();
2. ÑéÖ¤ºÍÐÞ¸´Êý¾Ý¿â
// ÑéÖ¤ºÍÐÞ¸´Êý¾Ý¿â
SqlCeEngine engine = new SqlCeEngine("Data
Source=AdventureWorks.sdf");
if (false == engine.Verify())
{
MessageBox.Show("Database is corrupted.");
engine.Repair(null,
RepairOption.RecoverCorruptedRows);
}
3. ѹËõÊý¾Ý¿â
// ѹËõÊý¾Ý¿â
// ͨ¹ý´ÓÏÖÓÐÎļþн¨Êý¾Ý¿âÎļþÀ´»ØÊÕ SQL Server Mobile
Êý¾Ý¿âÖÐÀ˷ѵĿռ䡣
// ´Ë·½·¨»¹¿ÉÓÃÀ´¸ü¸ÄÊý¾Ý¿âµÄÅÅÐò˳Ðò¡¢¼ÓÃÜ»òÃÜÂëÉèÖá£
//
¸ÃÁ¬½Ó×Ö·û´®Ö¸¶¨Ò»¸öÖ¸Ïò½«ÓÉ´Ë·½·¨´´½¨µÄÄ¿±êÊý¾Ý¿âµÄÁ¬½Ó¡£
// Èç¹ûÖ¸¶¨µÄÊý¾Ý¿âÒѾ´æÔÚ»òÕß¾ßÓÐÏàͬÃû³ÆµÄÁíÒ»ÎļþÒѾ´æÔÚ£¬Ôò»áÒý·¢Òì³£¡£
//
Èç¹ûΪÁ¬½Ó×Ö·û´®´«µÝ¿Õ×Ö·û´®£¬ÔòеÄÊý¾Ý¿âÎļþ½«¸Äд¾ÉµÄÊý¾Ý¿âÎļþ£¬
// µ«Ãû³Æ±£³Ö²»±ä¡£
SqlCeEngine engine = new
SqlCeEngine("Data
Source=AdventureWorks.sdf");
//engine.Compact(null);
engine.Compact("Data
Source=; Password=a@3!7f$dQ
;");
4. ÊÕËõÊý¾Ý¿â
// ÊÕËõÊý¾Ý¿â
// ͨ¹ý½«¿ÕÒ³Òƶ¯µ½ÎļþµÄ½áβȻºó½Ø¶Ï¸ÃÎļþ£¬
// À´»ØÊÕ SQL Server Mobile
Êý¾Ý¿âÖÐÀ˷ѵĿռ䡣
// Óë Compact ·½·¨²»Í¬£¬Shrink ·½·¨²»´´½¨ÁÙʱÊý¾Ý¿âÎļþ£¬
//
¶øÊǽ«ËùÓпÕÒ³ºÍδ·ÖÅäµÄÒ³¶¼ÒƵ½ÁËÎļþµÄ½áβ£¬È»ºó½Ø¶Ï£¬´Ó¶ø¼õСÊý¾Ý¿âµÄ×Ü´óС¡£
SqlCeEngine engine = new
SqlCeEngine("Data Source=AdventureWorks.
Ïà¹ØÎĵµ£º
-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comm ......
ÓÉÓÚϵͳÐèÇó£¬×î½üÔÚ¿ª·¢¹ý³ÌÖн«ÏµÍ³´ÓÔÀ´µÄMySQLתÒƵ½SQL
2000Ï£¬ÆäÖÐÓöµ½ÁËÖî¶àÎÊÌ⣬»¨·ÑÁËÎÒ²»ÉÙʱ¼ä¡£ÏÖÔÚ°ÑÎҵľÑéÄóöÀ´¸æËß´ó¼Ò£¬ºÃÈôó¼ÒÉÙ×ßÍä·£¬½ÚԼʱ¼ä¡£
¡¡¡¡Ê×ÏÈÊÇSQL
2000Êý¾Ý¿âµÄ°²×°ÎÊÌ⣬ÔÚ´ËÎÒÖ÷Òª½²Ð©¹ØÓÚSQL 2000µÄ°æ±¾Óë²Ù×÷ϵͳµÄ¼æÈÝÐÔÎÊÌ⣺SQL
2000×ܹ²ÓÐ7¸ö²»Í¬°æ±¾£¬ÊÊ ......
(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï×ÖµäµÄÕýÎı ......
ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005
Ò»¡¢Òª½øÐÐÁ½¸öµØ·½µÄÉèÖÃ
1 µã¿ªÊ¼—³ÌÐò—sql server 2005 –ÅäÖù¤¾ß—sql server 2005Ó¦ÓÃÅäÖÃÆ÷ ,Èçͼ£º
Ñ¡±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½ÓÖÐµÄ ½öʹÓÃtcp/ip»ò& ......
ËÄ¡¢ÁªºÏÊý×éµÄʹÓ÷½·¨
ÁªºÏÊý×éÒÔÇ°±»³ÆΪPL/SQL±í¡£ÔÚ±íÖв»ÄÜʹÓÃÁªºÏÊý×飬ֻÄܽ«ËüÃÇÓÃ×÷³ÌÐòÉè¼ÆµÄ½á¹¹Ìå¡£Ö»ÄÜÔÚPL/SQLÖзÃÎÊÁªºÏÊý×é¡£
×¢Òâµ½ÁªºÏÊý×é´øÀ´µÄһЩ¹Ø¼üÎÊÌâÊǷdz£ÖØÒªµÄ¡£ÕâЩÎÊÌâʹÎÒÃǽéÉÜËüÃǵÄÓ÷¨Ê±£¬ÐèÒª²ÉȡһЩÌرðµÄ·½·¨¡£ÕâЩÎÊÌâ°üÀ¨£º
ÁªºÏÊý×é²»ÐèÒª³õʼ»¯£¬Ò²Ã»Óй¹Ô캯ÊýÓï·¨¡£ÔÚ ......