I’m trying to achieve a particular format when scripting table data in my SQL DB. I’ve checked a ton of posts, worked with each option in the SSMS script wizard, and can’t find the format/conditions I’m looking for. Currently, when I script the table data through the SSMS Wizard, I get results with explicit Insert statements for each item such as this :

What I would like is something in this format.

How do I achieve the second format? Are there options in the script wizard to achieve the second format and I’m just missing them?