Database

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)

SELECT ROUND((7.5169 * 745), 3) AS Result;

SELECT ROUND(5600.0905, 3) AS Result;

DECLARE @a FLOAT, @b FLOAT, @c FLOAT;
SET @a = 7.5169;
SET @b = 745;
SET @c = @a * @b;
SELECT ROUND(@c, 3) AS Result;

DECLARE @a DECIMAL(18, 4), @b DECIMAL(18, 4), @c DECIMAL(18, 4);
SET @a = 7.5169;
SET @b = 745;
SET @c = @a * @b;
SELECT ROUND(@c, 3) AS Result;

select price
, qty
, price*qty as Val
, round(CONVERT(decimal(12,4),price)* CONVERT(decimal(12,4),qty),3) as RoundVal
from dbo.[round] 

avi_dadi2002 wrote:

my query is fetching 500 million records