sql-generate-insert icon indicating copy to clipboard operation
sql-generate-insert copied to clipboard

Published 20 hours ago • verified publisher icon drumsta

A Fix for Missing Closing Paranthesis in Column List

Open anar-khalilov opened this issue 7 years ago • 1 comments

When I executed the SP with the following settings, it cause a syntax error because no closing parathesis was specified for column list: EXEC dbo.GenerateInsert @ObjectName='MyTable', @GenerateOneColumnPerLine=1, @PrintGeneratedCode=1

As I delved into the code, I discovered a simple solution was adding a CrLf character BEFORE each column name and not adding it for the first column.

anar-khalilov avatar Mar 27 '17 08:03 anar-khalilov

@drumsta, could you please review this fix?

anar-khalilov avatar Jun 14 '22 14:06 anar-khalilov