用于复制父项和子项logging的SQL
我想找出创build一个SQL语句(在SQL Server中)复制父logging和所有子logging的最佳方法。 我以下面为例, — duplicate the order insert into Orders (CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry) select CustomerID, EmployeeID, getdate(), RequiredDate, null, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry from Orders where OrderID = @OrderID — find ID of duplicated order declare @NewOrderID int; select @NewOrderID = […]