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

SQL Server¹ÊÕÏÐÞ¸´¼¼ÇÉ

SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔ­ÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã±ØÐë¼ÇסµÄÊǽ«±¸Ó÷þÎñÆ÷Ìæ»»ÉÏÏßÖ»ÊÇÍê³ÉÁËÒ»°ëµÄ¹ÊÕÏÐÞ¸´¹¤×÷¡£
Òª±£Ö¤ÄãµÄÓ¦ÓÃÕý³£¹¤×÷£¬ÔÚÊý¾Ý¿âÍⲿ»¹ÓÐÐí¶à×¢ÒâÊÂÏî¡£ÕâÆäÖаüÀ¨µÇ¼ÐÅÏ¢¡¢Êý¾Ý¿âÓû§¡¢µ÷¶ÈÈÎÎñ¡¢DTS ºÍ SSIS °ü¡¢¿ÉÖ´ÐÐÎļþ¡¢ÏµÍ³Êý¾Ý¿âÖеĶÔÏó¡¢Í¬ÃûÊý¾Ý¿â¡¢Á´½Ó·þÎñÆ÷µÈµÈ¡£
ÓÐʱÕâЩϸСµÄÒÀÀµÖ»ÓÐÔÚÄã½øÐÐÒ»¸öÊý¾Ý¿â¹ÊÕϻָ´Ê±²Å»á·¢ÏÖ£¬ÕâÑùÄãÓÖ²»µÃ²»»¨·Ñ´óÁ¿Ê±¼ä½øÐе÷ÊÔºÍÆÀ¹Àµ¼ÖÂÕâ¸öÎÊÌâµÄ¸ùÔ´¡£´ËÍ⣬Ä㻹±ØÐëÈõڶþ̨·þÎñÆ÷ºÍÓ¦Óþ¡¿ÉÄÜ¿ìµØÉÏÏßÒÔ¼õÉÙÍ£»úʱ¼ä¡£Òò´Ë£¬ÌáÇ°×öÉèÖÃÊǷdz£ÖØÒªµÄ¡£
µ±Éæ¼°µ½¸ß¿ÉÓÃÐÔºÍSQL Server µÄÔÖÄѻָ´¹æ»®Ê±£¬ÄãÓ¦¸Ã½÷¼ÇÎÒ±¾ÈËËùϲ»¶µÄÒ»¸öÀ­¶¡ÑèÓï ——Si vis pacem, para bellum£¬ËüµÄÒâ˼·­Òë¹ýÀ´¾ÍÊÇ“Èç¹ûÄãÏëÒªµÃµ½ºÍƽ£¬ÄǾ͵ÃÏÈ×÷ºÃÕ½Õù×¼±¸¡£”¼ÇסÕâÒ»µãºó£¬ÈÃÎÒÃÇÀ´¿´¿´Ò»Ð©¿ÉÄÜ»áÓöµ½µÄÎÊÌâ¡£ÎÒÒ²½«½¨Ò鼸¸öÔ¤ÏÈ¿ÉÒÔÍê³ÉµÄÈÎÎñ£¬ÒÔÈ·±£Êý¾Ý¿â¹ÊÕϻָ´¹ý³Ì¿ìËÙÓÐЧµØÍê³É¡£
SQL Server µÇ¼ÐÅÏ¢ÓëÊý¾Ý¿âÓû§
ÄãµÄ¹ÊÕϻָ´·þÎñÆ÷Ó¦¸Ã±¸·ÝËùÓеĵǼÐÅÏ¢ºÍÊý¾Ý¿âÓû§£¬°üÀ¨ÃÜÂë¡£µÇ¼ÐÅÏ¢¿ÉÒÔÔÚÈκÎʱºò´´½¨£¬µ«ÊÇÈç¹ûÄãʹÓÃÈÕÖ¾´«Êä»òÊý¾Ý¿â¾µÏñ£¬ÄãµÄÊý¾Ý¿â½«´¦Àí»Ö¸´×´Ì¬£¬ÕâÑùÄãÖ»ÓÐÔÚËüÃÇÖØÐÂÉÏÏߺó²ÅÄÜÍê³É»Ö¸´¹ý³Ì¡£
ʹÓà Windows ÈÏÖ¤£¬¿ÉÒÔºÜÈÝÒ׵ؽ«µÇ¼ÐÅÏ¢Ó³Éäµ½Êý¾Ý¿âÓû§¡£È»¶ø£¬Èç¹ûÄãʹÓõÄÊÇ SQL ÈÏÖ¤£¬ÄÇôÄãÐèÒªÊÖ¶¯µØÔÚÄã´ÓÁíÒ»¸ö·þÎñÆ÷»ñµÃµÄÊý¾Ý¿âÉÏÖØн¨Á¢µÇ¼ÐÅÏ¢ÓëÊý¾Ý¿âÓû§µÄÁ¬½Ó¡£Òò´Ë£¬ÄãÔÚǨÒÆÊý¾Ý¿âʱ»á¶ªÊ§µÇ¼ÐÅÏ¢ºÍÊý¾Ý¿âÓû§Ö®¼äµÄÁ¬½Ó¡£
µ±ÄãÔÚµÚ¶þ̨·þÎñÆ÷Éϻָ´Êý¾Ý¿âºó£¬ÔËÐÐÕâЩ´úÂ룺
USE YourDatabaseName
EXEC sp_change_Users_Login 'UPDATE_ONE', YourDBUserName, YourLogin
±£³ÖµÇ¼ÐÅϢͬ²½µÄÁíÒ»¸ö·½·¨ÊÇ×ñÑ­ Microsoft Knowledge Base ÉϹØÓÚ ÔÚ SQL Server ʵÀýÖ®¼ä´«ÊäµÇ¼ÐÅÏ¢ºÍÃÜÂë µÄÎÄÕµIJ½Öè¡£ÕâƪÎÄÕ²ûÊöÁËÈçºÎʹÓÃԭʼµÄ SID ½Å±¾»¯µÇ¼ÐÅÏ¢¡£µ±ÔÚ¹ÊÕϻָ´Êý¾Ý¿â·þÎñÆ÷ÉÏ´´½¨ÕâЩµÇ¼ÐÅϢʱ£¬µÇ¼ÐÅÏ¢ÓëÊý¾Ý¿âÓû§Ö®¼äµÄÁ¬½Ó»á±»±£´æ£¬ÕâÑùÄã¾Í²»±ØÔËÐÐÉÏÃæµÄ½Å±¾ÐÞ¸´¹ÂÁ¢µÄÓû§¡££¨À´Ô´£º±ÈÌØÍø£©
¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄÓµÓÐÊ®ÄêITÅàѵ¾­Ñ飬רעÖйú¸ß¶ËITÅàѵÊÇÖйú¸ß¶ËITÅàѵµÚһƷÅÆ£¬Ìá¹


Ïà¹ØÎĵµ£º

sqlµÄ INNER JOIN, left join,right joinÓï·¨

inner join(µÈÖµÁ¬½Ó) Ö»·µ»ØÁ½¸ö±íÖÐÁª½á×Ö¶ÎÏàµÈµÄÐÐ
left join(×óÁª½Ó) ·µ»Ø°üÀ¨×ó±íÖеÄËùÓмǼºÍÓÒ±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
right join(ÓÒÁª½Ó) ·µ»Ø°üÀ¨ÓÒ±íÖеÄËùÓмǼºÍ×ó±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
INNER JOIN Óï·¨£º
INNER JOIN Á¬½ÓÁ½¸öÊý¾Ý±íµÄÓ÷¨£º
SELECT * from ±í1 INNER JOIN ±í2 ON ±í1.×ֶκÅ=±í2 ......

SQL¼ÓÃÜÊý¾Ý ÍõÑà½Ü

ÔÚÍøÂçÉÏ·¢ËÍÊý¾Ý¶¼»á·¢ÉúһЩÑÏÖصݲȫÎÊÌ⣬ÍøÂç×î´óµÄµ£ÓÇÔÚÓÚÓÐÈË¿ÉÒÔ²¶»ñÊý¾Ý£¬sqlserverÖ§³Ö²ÉÓÃÖ¤ÊéÀ´¼ÓÃÜ
1£®´´½¨Ö¤Êé
create master key encryption by
password = 'administrator123'
--ÓÃÃÜÂëadmini--
create certificate c1
encryption by password = 'administrator123'
with subject = 'c1 certific ......

sqlÅжϺ¯Êý???

¹¦ÄÜ£ºÐ¡Ð´½ð¶îת»»³É´óд
²ÎÊý£º@LowerMoney Сд½ð¶î ¼ÓÉÏСÊýµã×¿ÉÒÔ±£Áô38λ
Êä³ö£º´óд½ð¶î
¼ò½é£ºSQL°æ Сд½ð¶îת»»³É´óд½ð¶î£¨×î¶à¿ÉÒÔ¾«È·µ½Ð¡ÊýµãËÄ룩
×¢£º      Decimal Êý¾ÝÀàÐÍ×î¶à¿É´æ´¢ 38 ¸öÊý×Ö
תÔØ£ºÇë±£ÁôÒÔÉÏÐÅÏ¢,лл£¡£¡£¡
********************************* ......

magento ÔÚMagentoÖÐʹÓÃ×Ô¼ºÐ´µÄSQLÓï¾ä


MagentoµÄModels
ºÍCollection
 ºÜÇ¿´ó£¬Ê¹ÓÃËüÃÇ¿ÉÒԺܷ½±ãµÄ²éѯºÍ²Ù×÷Êý¾Ý¿â¡£µ«ÊÇÓÐЩ³¡ºÏ£¬ÒòΪһЩÌØÊâÐèÇó»ò¶ÔMagentoµÄÁ˽ⲻ¹»É¿ÉÄÜ»áÐèÒª×Ô¼ºÊÖдSQLÓï¾äÀ´²éѯºÍ²Ù×÷Êý¾Ý¿â¡£ÒÔÏ·ֱðÊǶÁдÊý¾Ý¿âµÄ´úÂë¡£

// For Read
// fetch read database connection that is used in Mage_Core modul ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ