Database

Nico Haegens wrote:

I want to insert 2 people who live at the same address

Nico Haegens wrote:

I would like to know how to return the primary key(the column is always called id) ...All my insert statements are in stored procedures

ALTER procedure [dbo].[AddressInsert](@street varchar(255), @streetnumber varchar(255), @busnumber varchar(255), @placeid bigint, @newid bigint output) as begin  
set @newid = next value for dbo.baseidseq 
insert into [Address](baseid, street, streetnumber, busnumber, placeid) values(@newid, @street, @streetnumber, @busnumber, @placeid) end 

Nico Haegens wrote:

Person A comes along to one of my client's employees and gives his info and a certain address.

Person B comes along to another one of my client's employees, gives his info and the same address as person A.

here is what currently happens in my app:

Nico Haegens wrote:

Problem is,

declare @newid bigint = next value for dbo.baseidseq 
 BEGIN TRANSACTION
 begin try
 insert into [Address](id, street, streetnumber, busnumber, placeid) 
 values(@newid, @street, @streetnumber, @busnumber, @placeid) 
 
 end try
 begin catch
	if ERROR_NUMBER()=2627
	begin
	set @newid = (select baseid from [Address] 
	where street like @street and streetnumber like @streetnumber and busnumber like @busnumber and placeid=@placeid) 
	end
 else
	rollback transaction
 END catch
 if @@TRANCOUNT>0
 COMMIT TRANSACTION
 select @newid

SELECT * FROM tablename WHERE datefield > DateADD(mi, -30, Current_TimeStamp)