SQL Studio

INSERT
INSERT
INTO
entity_logicalname 
SET { column_name = { value | NULL } } [ ,...n ]
  • in cases where SQL Studio can't automaticly determine a lookup type when setting a field use the lookup syntax of 'entityname:GUID'
Examples
insert into contact
set firstname = 'John' , lastname = 'Jones'