27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#A') is null
drop table #A
Go
Create table #A([LabelID] INT IDENTITY,[LabelName] nvarchar(24))
GO
if not object_id(N'Tempdb..#B') is null
drop table #B
Go
Create table #B([CarName] nvarchar(26),[LabelID] int)
Go
--测试数据结束
DECLARE @name NVARCHAR(200)='测试'
DECLARE @id INT
IF(EXISTS(SELECT * FROM #A WHERE LabelName=@name))
BEGIN
INSERT INTO #B
(
CarName,
LabelID
)
VALUES
( N'这里写啥?', -- CarName - nvarchar(26)
(SELECT TOP 1 LabelID FROM #A WHERE LabelName=@name ) -- LabelID - int
)
END
ELSE
BEGIN
INSERT #A
(
LabelName
)
VALUES (@name
)
SELECT @id=SCOPE_IDENTITY()
INSERT INTO #B
(
CarName,
LabelID
)
VALUES
( N'这里写啥?', -- CarName - nvarchar(26)
@id -- LabelID - int
)
END
SELECT * FROM #B