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

¶Ô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


Ïà¹ØÎĵµ£º

SQL ·ÖÒ³²éѯЧÂÊ

ÓÃT-SQL×öÊý¾Ý¿â·ÖÒ³²éѯҲÓкü¸ÄêÁË£¬µ«¶ÔÓÚ¸÷ÖÖ²éѯ·½·¨µÄд·¨Ò»ÖÁ¶¼Ã»ÔõôȥÀí»á£¬×î½ü²ÎÓëÁ˼¸¸öÏîÄ¿µÄ¿ª·¢£¬¼¸¸öÏîÄ¿ÖзÖÒ³²éѯµÄд·¨Ò²²»Ïàͬ£¬ÕâÒ²ÈÃÎÒ²úÉúÁËÈ·Èϼ¸ÖÖд·¨Ð§ÂÊÎÊÌâµÄÐËȤ¡££¨×¢£ºÎÒËù˵µÄ¼¸ÖÖд·¨¶¼ÊÇÐèÒª·µ»Ø×ܼǼÊýµÄ·ÖÒ³£©
1¡¢Éú³É²âÊÔÊý¾Ý
select a.* into test from sys.columns a,sys.colu ......

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

SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔ­ÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã±ØÐë¼ÇסµÄÊǽ«±¸Ó÷þÎñÆ÷Ìæ»»ÉÏÏßÖ»ÊÇÍê³ÉÁËÒ»°ëµÄ¹ÊÕÏÐÞ¸´¹¤×÷¡£
Òª±£Ö¤ÄãµÄÓ¦ÓÃÕý³£¹¤×÷£¬ÔÚÊý¾Ý¿â ......

sql server ´´½¨±íʱΪÁÐÌí¼Ó˵Ã÷


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'±íà ......

SQL´¥·¢Æ÷[ת]


Ò»¡¢´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷&rdqu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ