Explicitly Assign Value
You can explicitly assign value i.e. GUID when inserting the records in the table.
Insert Into Table_Name (Column1,Column2) Values (value1,value2)
For Example:
INSERT INTO Product (ID, ProductName) VALUES ('E2C74A6E-52CC-4BCC-A00A-62B7A7D6D234', 'Custom GUID Record');
Output:
What is a GUID in SQL Server?
Globally Unique Identifiers, or GUIDs, are 16-byte (128-bit) binary data types in SQL Server that contain values and are represented by unique identifiers. Each table modeling procedure starts with a business key, surrogate key, identity key, etc. An increasingly distinct identity is required when common business entities need to be joined for data storage and analytics.
GUIDs are utilized in these situations since they are distinct for all servers, databases, and tables. Furthermore, when compared to other data formats, GUIDs might be somewhat large.