DELETE FROM [AnagDevices] WHERE (([IdxDevice] = @Original_IdxDevice) AND ([DeviceSecret] = @Original_DeviceSecret) AND ((@IsNull_Dominio = 1 AND [Dominio] IS NULL) OR ([Dominio] = @Original_Dominio)) AND ((@IsNull_UsrName = 1 AND [UsrName] IS NULL) OR ([UsrName] = @Original_UsrName)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([DeviceName] = @Original_DeviceName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([dataOraEnabled] = @Original_dataOraEnabled) AND ([dataOraLastSeen] = @Original_dataOraLastSeen) AND ((@IsNull_lastIPv4 = 1 AND [lastIPv4] IS NULL) OR ([lastIPv4] = @Original_lastIPv4))) INSERT INTO [AnagDevices] ([DeviceSecret], [Dominio], [UsrName], [MatrOpr], [DeviceName], [Description], [dataOraEnabled], [dataOraLastSeen], [lastIPv4]) VALUES (@DeviceSecret, @Dominio, @UsrName, @MatrOpr, @DeviceName, @Description, @dataOraEnabled, @dataOraLastSeen, @lastIPv4); SELECT IdxDevice, DeviceSecret, Dominio, UsrName, MatrOpr, DeviceName, Description, dataOraEnabled, dataOraLastSeen, lastIPv4 FROM AnagDevices WHERE (IdxDevice = SCOPE_IDENTITY()) SELECT * FROM AnagDevices UPDATE [AnagDevices] SET [DeviceSecret] = @DeviceSecret, [Dominio] = @Dominio, [UsrName] = @UsrName, [MatrOpr] = @MatrOpr, [DeviceName] = @DeviceName, [Description] = @Description, [dataOraEnabled] = @dataOraEnabled, [dataOraLastSeen] = @dataOraLastSeen, [lastIPv4] = @lastIPv4 WHERE (([IdxDevice] = @Original_IdxDevice) AND ([DeviceSecret] = @Original_DeviceSecret) AND ((@IsNull_Dominio = 1 AND [Dominio] IS NULL) OR ([Dominio] = @Original_Dominio)) AND ((@IsNull_UsrName = 1 AND [UsrName] IS NULL) OR ([UsrName] = @Original_UsrName)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([DeviceName] = @Original_DeviceName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([dataOraEnabled] = @Original_dataOraEnabled) AND ([dataOraLastSeen] = @Original_dataOraLastSeen) AND ((@IsNull_lastIPv4 = 1 AND [lastIPv4] IS NULL) OR ([lastIPv4] = @Original_lastIPv4))); SELECT IdxDevice, DeviceSecret, Dominio, UsrName, MatrOpr, DeviceName, Description, dataOraEnabled, dataOraLastSeen, lastIPv4 FROM AnagDevices WHERE (IdxDevice = @IdxDevice) dbo.stp_Dev_delByDeviceName dbo.stp_Dev_delByDeviceSecret dbo.stp_Dev_delByDominioUser dbo.stp_Dev_delByDominioUserDeviceName dbo.stp_Dev_getByDeviceName dbo.stp_Dev_getByDeviceSecret dbo.stp_Dev_getByIdxDipendente dbo.stp_Dev_insert dbo.stp_Dev_updateIP