Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö´ÐÐ˳Ðò

±ê×¼µÄ sql µÄ½âÎö˳ÐòΪ: (1).from ×Ӿ䠠×é×°À´×Ô²»Í¬Êý¾ÝÔ´µÄÊý¾Ý
 (2).where ×Ӿ䠠»ùÓÚÖ¸¶¨µÄÌõ¼þ¶Ô¼Ç¼½øÐÐɸѡ
 (3).group by ×Ӿ䠠½«Êý¾Ý»®·ÖΪ¶à¸ö·Ö×é 
 (4).ʹÓþۺϺ¯Êý½øÐмÆËã
 (5).ʹÓàhaving  ......

ѧϰSQL SERVERÓαêµÄʹÓÃ

 ¡¡¡¡ÔÚÕâÒ»²½ÖУ¬ÐèÒªÖ¸¶¨ÓαêµÄÊôÐԺ͸ù¾ÝÒªÇó²úÉúµÄ½á¹û¼¯¡£ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÖ¸¶¨Ò»¸öÓαꡣ
¡¡¡¡ÐÎʽ1£¨ANSI 92£©
DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSOR
FOR select_statement
[FOR {READ ONLY | UPDATE ][OF column_list]}]
¡¡¡¡ÐÎʽ2
DECLARE cursor_name CURSOR
[LOCAL | GLOBAL]
[FORWARD ......

SQL ·ÖÒ³²éѯЧÂÊ

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

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'±íà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ