Как вставить столбец из другой таблицы при вставке его из userdefined datatable?
#sql-server #sql-сервер Вопрос: CREATE PROC [dbo].[usp_InsertBulkShipmentData] ( @RetVal VARCHAR(1000) OUTPUT, @ship dbo.ShipmentData READONLY ) AS DECLARE @ShipmentID BIGINT Declare @Output table (id int) BEGIN INSERT INTO dbo.Shipment (ShipmentType,scaccode,ShipmentControl,countryLoading,PortLoading,ShipperName,ShipperAddressOne,ShipperCity,ShipperCountry,ShipperProvince, ShipperZip,ShipperPhone,ShipperEmail,ConsigneeName,ConsigneeAddressOne,ConsigneeCity,ConsigneeCountry,ConsigneeState,ConsigneeZip, ConsigneePhone,ConsigneeEmail,ResponseCode,astrayExportDate,bondType,bondDestPort,bondOnwardscac,bondCarrierIRS,…