In some cases i work directly with data through the Edit top 200 (or what it is set to) in SSMS. I find it particularly useful when I get some sort of data that is pre-worked through Excel or similar from our customers and the volume is low.
But in come cases we have columns that are of type UniqueIdentifier (GUIDs) that are required which I else would use NewID() to generate when writing SQL directly.
So I have all information I need to just copy/paste data from lets say a sheet of excel into the GUI in SSMS "Edit top 200.." except from a column at will define a new GUID. I can't just leave it empty/NULL either, that will generate an error message.
The embedded example tries to show what I mean. The first row is already present with a GUID (#2) and have data for the rest also (#1). So I have data for every column that is needed for those under #1 with red square, but if I put in such data in an empty row I will need to create a GUID in the first empty column under #2.
Have anyone seen a way to achieve what I try to describe above? Is there a way to get the GUI to somehow generate a NewID() in such columns?