SET @cnee = (SELECT ISNULL(cnee,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @Name = (SELECT ISNULL(Name,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @BookingNo = (SELECT ISNULL(BookingNo,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @OrderNo = (SELECT ISNULL(OrderNo,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @POL = (SELECT ISNULL(POL,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @ETD = (SELECT CONVERT(varchar(16),ETD,103) FROM #TMP_SHIP WHERE e_id = @v_row)
SET @MainVessel = (SELECT ISNULL(MainVessel,'') FROM #TMP_SHIP WHERE e_id = @v_row)
SET @CWRef = (SELECT ISNULL(CWRef,'') FROM #TMP_SHIP WHERE e_id = @v_row)
像这种情况能不能通过一句语句实现?谢谢!
SELECT @cnee= ISNULL(AGN_RecordNo,''),@Name= ISNULL(AGN_JobNo,'') FROM L_Agent