SQL Server DDL触发器记录表结构修改
创建 DatabaseLog 表和 DLL 触发器 DDL_DatabaseLog，记录修改表结构操作USE mjkq;
GO
IF EXISTS (SELECT * FROM sys.tables WHERE name = 'DatabaseLog')
BEGIN
DROP TABLE [dbo].[DatabaseLog];
END;
GO
CREATE TABLE [dbo]...
SqlServer SqlDataAdapter 用例
SqlDataAdapter 可以实现 UpdateOrInsertpublic void UpdateOrInsertLocStatus(List<RealTimeNearbyLocationCard> status)
{
var dt = new DataTable();
using (SqlConnection conn = new SqlConnectio...