INSERT INTO Cars (ID, FirstName, LastName, Manufacturer, Model, Year, Color,
EngineSize, TransmissionType, Sold, Value)
VALUES ('NEWID()', 'Tony', 'Shannon', 'Volkswagen', 'Polo', '2018', 'Orange',
'1.0', 'Manual', 'false', '16000');
我是SQL Server的新手,不明白为什么会出现以下错误:
"Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier."
我已将ID列设置为uniqueidentifier,但不知道如何生成它。
请注意,我是新手,非常感谢您的帮助!
NEWID()
。 - Felix Pamittan