Is it possible to generate a GUID/UUID with T-SQL? I would like to insert a GUID with each INSERT done as a reference.Here is the current code:INSERT tb_alerts ( f_alertname, f_alertgenerated, f_machineaffected )SELECT 'Machine Not Reporting', GETDATE(), x.f_itemGUIDFROM tb_locationsmachines AS xWHERE x.f_machinelastreported < DATEADD(MINUTE, -15, GETDATE()) AND NOT EXISTS (SELECT * FROM tb_alerts AS y WHERE y.f_machineaffected = x.f_itemGUID)
And I would like something like the following:INSERT tb_alerts ( f_alertname, f_alertGUID f_alertgenerated, f_machineaffected )SELECT 'Machine Not Reporting', GUID() GETDATE(), x.f_itemGUIDFROM tb_locationsmachines AS xWHERE x.f_machinelastreported < DATEADD(MINUTE, -15, GETDATE()) AND NOT EXISTS (SELECT * FROM tb_alerts AS y WHERE y.f_machineaffected = x.f_itemGUID)
I've searched the forum and Google with no luck, so I'm passing this off to the experts.Thanks in advance,Matt