34,575
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE dbo.SelectCompanyID
@company nvarchar(100),
@companyid int output
AS
if EXISTS(select companyid from tcompany where company = @company)
begin
select @companyid=companyid from tcompany where company = @company
end
else
begin
insert tcompany(company) values(@company)
set @companyid = @@IDENTITY
end
RETURN @companyid