Unclosed quotation mark after the character string.

Question

I am using Azure Automation Runbooks to insert some data into Azure SQL.

We have 17k lines of data and this below query is being failed for only 3 rows. Not sure what's wrong here.

Answer 1

One of the value contains single quotation thats why its breaking the sql insert command. So it was replaced & then executed.

Answer 2

@D Mallikarjuna Reddy , thank you for sharing the solution with the community.

You may also consider using the -variable parameter with Invoke-Sqlcmd so that the query string does not terminate unexpectedly when delimiters like ";" or singlequotes are there in the values to be inserted. For details, see -variable in Invoke-Sqlcmd