我已经在这里捱了两个小时了。我想选择或插入一条记录。如果记录存在,则选择它的ID,否则将其插入并获取新插入的ID。目前,我正在尝试运行这个功能,但仍然出现错误。
SELECT CASE WHEN (SELECT COUNT(*) FROM Domains WHERE Domain = @domain)>0
THEN
(SELECT Domain_ID FROM Domains WHERE Domain = @domain)
ELSE
INSERT INTO Domains(Domain_ID,Domain,Disabled,Description) VALUES(@Domain_ID,@Domain,@Disabled,@Description);
IF EXISTS (SELECT 1 FROM Domains WHERE Domain = @domain)
而不是SELECT CASE WHEN (SELECT COUNT(*) FROM Domains WHERE Domain = @domain)>0
。 - LittleBobbyTables - Au Revoir