¶Ô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
Ïà¹ØÎĵµ£º
ÏÖÏó£º
ÎҵĵçÄÔ--¹ÜÀí--·þÎñ--mssqlserver ·þÎñ --Æô¶¯
±¨´í£¬1068£¬
»òÕߣ¬sqlserver ÅäÖùÜÀíÆ÷ÖÐSqlServer Ö÷·þÎñÆô¶¯ ±¨´í Ìáʾ˵ÒÀ´æµÄ·þÎñ»òÕß×é¼þûÓÐÆô¶¯£¬
ÔÒò£ºÎÒÊDzËÄñ£¬²»Ì«Àí½âµ½µ×ʲôÔÒò£¬µ«ÊÇÕÒµ½Á˽â¾ö·½·¨
½â¾ö·½·¨£º
SqlSe ......
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Str
{
public partial class Form1 : F ......
ÒÔÇ°ÔÚ2000Àï¿ÉÒÔÊý¾Ýµ¼Èëµ¼³ö£¬µ±È»ÔÚ2005ÀïÒ²²»ÀýÍ⣬ͬÑùÓÐÕâÑùµÄ²Ù×÷£¬Ö»ÊÇÔÚ²Ù×÷ÉϺÍ2000ÓеãÇø±ð£¬ÏÂÃæͨ¹ýͼÎĵķ½·¨½ÌÄãÔõÑùµ¼Èëµ¼³öÊý¾Ý¡£
²Ù×÷²½Ö裺
1¡¢Èçͼ£¬ÔÚ“¶ÔÏó×ÊÁϹÜÀíÆ÷”ÀÓÒ»÷ÄãÒªµ¼Èëµ¼³öÊý¾ÝµÄÊý¾Ý¿â£¬Ñ¡Ôñ“ÈÎÎñ”ÀïµÄµ¼ÈëÊý¾Ý»òµ¼³öÊý¾Ý£¬ÎÒÕâÀïÒÔµ¼ÈëÊý¾ÝΪÀý£¬µ¼³öÊ ......
ǶÈëSQLÓïÑÔ:
ÎÒ½«Ò»¸ösqlÁ´½Óµ½Êý¾Ý¿â£¬¸ÃÊý¾Ý¿âÃûΪmaster(ϵͳÊý¾Ý¿â)
then ¸øÊý¾Ý¿âÌí¼ÓÐÂ±í£¬½¨Á¢Èý¸ökey£ºuserid(int),name(char(10)),password(char(10))
ÔÚ´°ÌåÖÐŪÈý¸ötextbox¿Ø¼þ£¬·Ö±ð¶¨ÒåNameÊôÐÔΪuserid,name,password;
ÔÙÀ´Ò»¸öbutton
ÒÔÏÂÊÇForm1.csÖеĴúÂë
using System;
using System.Coll ......