SQL Server OPENJSON Publisher

A publisher use to populate a table in SQL Server. Create a JSON document where the field names match the names of the SQL Table columns. This document will become your input and then the publisher you just need the connection string and the Table name.

Connection String format example:

server=<url_Host_address>;Database= <databaseName>;Uid=<username>;Pwd=<Password>;AllowUserVariables=True

Last updated