注意事项：
1.修改Database设置
alter database set enable_broker with rollback immediate;
2.SQL的查询语法中不能使用 [*] 的方式
[错误的：] select * From [dbo].[alarm_table]
[正确的] select sn,address,create_time From [dbo].[alarm_table]
资源文件列表
.gitattributes , 2518
.gitignore , 2806
.vs/SqlDependency_Test/v15/.suo , 47616
.vs/SqlDependency_Test/v15/Server/sqlite3/db.lock , 0
.vs/SqlDependency_Test/v15/Server/sqlite3/storage.ide , 4096
.vs/SqlDependency_Test/v15/Server/sqlite3/storage.ide-shm , 32768
.vs/SqlDependency_Test/v15/Server/sqlite3/storage.ide-wal , 671592
README.md , 315
SqlDependency.bak , 3260416
SqlDependency[DB].sql , 2769
SqlDependency[Table].sql , 1788
SqlDependency_Test/App.config , 358
SqlDependency_Test/Form1.Designer.cs , 9388
SqlDependency_Test/Form1.cs , 3040
SqlDependency_Test/Form1.resx , 554929
SqlDependency_Test/Program.cs , 499
SqlDependency_Test/Properties/AssemblyInfo.cs , 1338
SqlDependency_Test/Properties/Resources.Designer.cs , 2772
SqlDependency_Test/Properties/Resources.resx , 5496
SqlDependency_Test/Properties/Settings.Designer.cs , 1051
SqlDependency_Test/Properties/Settings.settings , 242
SqlDependency_Test/SqlDependency_Test.csproj , 3778
SqlDependency_Test/bin/Debug/SqlDependency_Test.exe , 383488
SqlDependency_Test/bin/Debug/SqlDependency_Test.exe.config , 358
SqlDependency_Test/bin/Debug/SqlDependency_Test.pdb , 24064
SqlDependency_Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache , 7338
SqlDependency_Test/obj/Debug/SqlDependency_Test.Form1.resources , 370636
SqlDependency_Test/obj/Debug/SqlDependency_Test.Properties.Resources.resources , 180
SqlDependency_Test/obj/Debug/SqlDependency_Test.csproj.CoreCompileInputs.cache , 42
SqlDependency_Test/obj/Debug/SqlDependency_Test.csproj.FileListAbsolute.txt , 1405
SqlDependency_Test/obj/Debug/SqlDependency_Test.csproj.GenerateResource.cache , 1012
SqlDependency_Test/obj/Debug/SqlDependency_Test.csprojAssemblyReference.cache , 11606
SqlDependency_Test/obj/Debug/SqlDependency_Test.exe , 383488
SqlDependency_Test/obj/Debug/SqlDependency_Test.pdb , 24064
SqlDependency_Test/obj/Debug/TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs , 0
SqlDependency_Test/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs , 0
SqlDependency_Test/obj/Debug/TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs , 0
SqlDependency_Test.sln , 1001