Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT basic.*
- FROM OPENROWSET (BULK 'C:\Catalog\Management\Basic.json', SINGLE_CLOB) as j
- CROSS APPLY OPENJSON(BulkColumn)
- WITH(
- FileID int,
- Part varchar(50),
- PartTermID int,
- Position int,
- BaseVehicleID int,
- SubModelID int,
- EngineBaseID int,
- Qty int,
- Notes varchar(MAX)
- ) AS basic
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement