您可以使用IF语句执行此操作
IF NOT EXISTS(SELECT TOP 1 1 FROM audioformats WHERE audioformat = @format)
BEGIN
INSERT INTO audioFormats (audioFormat)
VALUES ('Test')
SET @audioFormatId = SCOPE_IDENTITY()
END
ELSE
BEGIN
SELECT @audioFormatID = ID FROM audioformats WHERE audioformat = @format
END
或者你可以这样:
INSERT INTO audioformats (audioformat)
SELECT @format
FROM audioFormats
WHERE NOT EXISTS (SELECT TOP 1 1 FROM audioformats WHERE audioformat = @format)
SELECT @audioFormatID = ID FROM audioformats WHERE audioformat = @format