Click here to Skip to main content
15,302,644 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
jschell11-May-14 8:17
Memberjschell11-May-14 8:17 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens12-May-14 3:20
professionalNico Haegens12-May-14 3:20 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Richard.Berry10012-May-14 7:55
MemberRichard.Berry10012-May-14 7:55 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Eddy Vluggen12-May-14 8:49
professionalEddy Vluggen12-May-14 8:49 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Corporal Agarn12-May-14 9:45
professionalCorporal Agarn12-May-14 9:45 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
jschell12-May-14 10:31
Memberjschell12-May-14 10:31 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
Mycroft Holmes12-May-14 22:25
professionalMycroft Holmes12-May-14 22:25 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens13-May-14 2:18
professionalNico Haegens13-May-14 2:18 
Figured it out myself:
use try catch clause and check for error_number()=2627
SQL
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

GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Mycroft Holmes13-May-14 12:52
professionalMycroft Holmes13-May-14 12:52 
QuestionDatabase SQL Pin
Syafiqah Zahirah10-May-14 4:47
MemberSyafiqah Zahirah10-May-14 4:47 
AnswerRe: Database SQL Pin
Peter Leow10-May-14 5:24
professionalPeter Leow10-May-14 5:24 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 3:43
MemberSyafiqah Zahirah11-May-14 3:43 
AnswerRe: Database SQL Pin
Peter Leow11-May-14 4:13
professionalPeter Leow11-May-14 4:13 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 4:45
MemberSyafiqah Zahirah11-May-14 4:45 
GeneralRe: Database SQL Pin
Syafiqah Zahirah15-May-14 6:50
MemberSyafiqah Zahirah15-May-14 6:50 
GeneralRe: Database SQL Pin
Peter Leow15-May-14 14:47
professionalPeter Leow15-May-14 14:47 
QuestionArithmetic rounding Pin
Richard.Berry1009-May-14 11:04
MemberRichard.Berry1009-May-14 11:04 
AnswerRe: Arithmetic rounding Pin
Richard Andrew x649-May-14 12:26
professionalRichard Andrew x649-May-14 12:26 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 20:58
MemberRichard.Berry1009-May-14 20:58 
AnswerRe: Arithmetic rounding Pin
Andrius Leonavicius9-May-14 15:02
professionalAndrius Leonavicius9-May-14 15:02 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 20:45
MemberRichard.Berry1009-May-14 20:45 
GeneralRe: Arithmetic rounding Pin
Andrius Leonavicius10-May-14 4:28
professionalAndrius Leonavicius10-May-14 4:28 
QuestionFetch records efficiently Pin
avi_dadi20029-May-14 9:15
Memberavi_dadi20029-May-14 9:15 
AnswerRe: Fetch records efficiently Pin
Richard Andrew x649-May-14 10:30
professionalRichard Andrew x649-May-14 10:30 
AnswerRe: Fetch records efficiently Pin
Richard MacCutchan9-May-14 21:49
mveRichard MacCutchan9-May-14 21:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.