¶ÔSQL Server 2008 R2¸ÐÐËȤStreamInsightÌØÐÔ
SQL Server 2008 R2µÄÊ®´ó±ä»¯£¨ÉÏ£©£¬SQL Server 2008 R2µÄÊ®´ó±ä»¯£¨Ï£© ÕâÊ®´óÌØÐÔÖÐÎұȽϸÐÐËȤµÄÊÇStreamInsight£ºÍ¨¹ýSQL Server 2008 R2еÄStreamInsight×é¼þ£¬Microsoft½øÈëÁ˸´ÔÓʼþ´¦Àí(Complex Event Processing£¬CEP)¾ºÕù£¬ÆäÖÐÏà¹ØµÄ¹©Ó¦ÉÌ»¹ÓÐOracle¡¢IBMºÍStreamBase¡£
SQL Server 2008 R2ÒýÈëStreamInsight¹¦ÄÜ£¬¿ÉÒÔΪ¿ª·¢ÈËÔ±ÌṩһÌ×È«·½Î»µÄƽ̨À´¿ª·¢»ùÓÚʼþµÄÓ¦ÓóÌÐò¡£Ó봫ͳµÄ»ùÓÚ²éѯµÄÓ¦ÓóÌÐòÓÐËù²»Í¬£¬»ùÓÚʼþµÄÓ¦ÓóÌÐòÐèÒªÔÚµÍÑÓ³ÙµÄÇ°ÌáÏÂѸËÙ´¦Àíº£Á¿Êý¾Ý¡£
StreamInsightϵÁÐ-What it is
StreamInsightϵÁÐ-Adapter
StreamInsightϵÁÐ-QueryTemplate\QueryBinder\Query
Hosting StreamInsight applications using WCF
MSDNÕ¾µã£ºhttp://msdn.microsoft.com/zh-cn/sqlserver/ee476990(en-us).aspx
MSDNÎĵµ£ºhttp://msdn.microsoft.com/en-us/library/ee362541(SQL.105).aspx
Ïà¹ØÎĵµ£º
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
ÔÚÍøÂçÉÏ·¢ËÍÊý¾Ý¶¼»á·¢ÉúһЩÑÏÖصݲȫÎÊÌ⣬ÍøÂç×î´óµÄµ£ÓÇÔÚÓÚÓÐÈË¿ÉÒÔ²¶»ñÊý¾Ý£¬sqlserverÖ§³Ö²ÉÓÃÖ¤ÊéÀ´¼ÓÃÜ
1£®´´½¨Ö¤Êé
create master key encryption by
password = 'administrator123'
--ÓÃÃÜÂëadmini--
create certificate c1
encryption by password = 'administrator123'
with subject = 'c1 certific ......
MagentoÊÇÔÚZend FrameworkµÄ»ù´¡Éϴ¶øÀ´£¬ÓÐÁ½ÖÖ·½Ê½¿ÉÒÔ´ÓMagentoµÄcollection»ñµÃÕæÕýµÄSQLÓï¾ä¡£
ÒÔ Mage::getResourceModel('reports/product_collection') ΪÀý£º
1
$collection=Mage::getResourceModel('reports/product_collection');
......
ÒÔÇ°ÔÚ2000Àï¿ÉÒÔÊý¾Ýµ¼Èëµ¼³ö£¬µ±È»ÔÚ2005ÀïÒ²²»ÀýÍ⣬ͬÑùÓÐÕâÑùµÄ²Ù×÷£¬Ö»ÊÇÔÚ²Ù×÷ÉϺÍ2000ÓеãÇø±ð£¬ÏÂÃæͨ¹ýͼÎĵķ½·¨½ÌÄãÔõÑùµ¼Èëµ¼³öÊý¾Ý¡£
²Ù×÷²½Ö裺
1¡¢Èçͼ£¬ÔÚ“¶ÔÏó×ÊÁϹÜÀíÆ÷”ÀÓÒ»÷ÄãÒªµ¼Èëµ¼³öÊý¾ÝµÄÊý¾Ý¿â£¬Ñ¡Ôñ“ÈÎÎñ”ÀïµÄµ¼ÈëÊý¾Ý»òµ¼³öÊý¾Ý£¬ÎÒÕâÀïÒÔµ¼ÈëÊý¾ÝΪÀý£¬µ¼³öÊ ......
IF NOT EXISTS (SELECT * from ::fn_listextendedproperty
(N'MS_Description' , N'SCHEMA',N'dbo',
N'TABLE',N'±íÃû', N'COLUMN',N'ÁÐÃû'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description',
@value=N'˵Ã÷ÄÚÈÝ' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'±íà ......