Advertisement
Guest User

Untitled

a guest
Feb 26th, 2020
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT basic.*
  2. FROM OPENROWSET (BULK 'C:\Catalog\Management\Basic.json', SINGLE_CLOB) as j
  3. CROSS APPLY OPENJSON(BulkColumn)
  4. WITH(
  5. FileID int,
  6. Part varchar(50),
  7. PartTermID int,
  8. Position int,
  9. BaseVehicleID int,
  10. SubModelID int,
  11. EngineBaseID int,
  12. Qty int,
  13. Notes varchar(MAX)
  14. ) AS basic
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement