Click here to Skip to main content
14,742,447 members
Home » Discussions » Database
   

Database

 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
PIEBALDconsult2-Jan-18 15:12
professionalPIEBALDconsult2-Jan-18 15:12 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 9:33
Memberkmoorevs4-Jan-18 9:33 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
Joe DiNatale4-Jan-18 12:10
MemberJoe DiNatale4-Jan-18 12:10 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 12:33
Memberkmoorevs4-Jan-18 12:33 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 12:35
professionalS Douglas7-Mar-18 12:35 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 12:31
professionalS Douglas7-Mar-18 12:31 
QuestionMore than interesting... Pin
Kornfeld Eliyahu Peter31-Dec-17 22:05
professionalKornfeld Eliyahu Peter31-Dec-17 22:05 
AnswerRe: More than interesting... Pin
Jörgen Andersson1-Jan-18 4:44
professionalJörgen Andersson1-Jan-18 4:44 
The return statement is never reached, because the raiserror exits the statement block.
So you should either add an else statement or add try and catch blocks. And if you use SqlServer 2012 or newer you should also consider using throw instead of raiserror.

You should also be careful with adding the sp_ prefix to your stored procedures, it doesn't mean "stored procedure".
Is the sp_ prefix still a no-no? - SQLPerformance.com[^]

This post should also be taken with a grain of salt, my brain is still pretty well baked.
Wrong is evil and must be defeated. - Jeff Ello

GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 5:31
professionalKornfeld Eliyahu Peter1-Jan-18 5:31 
GeneralRe: More than interesting... Pin
Jörgen Andersson2-Jan-18 6:28
professionalJörgen Andersson2-Jan-18 6:28 
SuggestionRe: More than interesting... Pin
Richard Deeming8-Jan-18 8:22
mveRichard Deeming8-Jan-18 8:22 
GeneralRe: More than interesting... Pin
Jörgen Andersson8-Jan-18 10:03
professionalJörgen Andersson8-Jan-18 10:03 
GeneralRe: More than interesting... Pin
Richard Deeming9-Jan-18 2:26
mveRichard Deeming9-Jan-18 2:26 
GeneralRe: More than interesting... Pin
Jörgen Andersson9-Jan-18 9:39
professionalJörgen Andersson9-Jan-18 9:39 
AnswerRe: More than interesting... Pin
jschell1-Jan-18 8:04
Memberjschell1-Jan-18 8:04 
GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 9:23
professionalKornfeld Eliyahu Peter1-Jan-18 9:23 
GeneralRe: More than interesting... Pin
ZurdoDev8-Jan-18 9:05
professionalZurdoDev8-Jan-18 9:05 
QuestionTrigger value > ? write in different table Pin
brian121026-Dec-17 14:44
Memberbrian121026-Dec-17 14:44 
AnswerRe: Trigger value > ? write in different table Pin
Victor Nijegorodov26-Dec-17 23:13
MemberVictor Nijegorodov26-Dec-17 23:13 
AnswerRe: Trigger value > ? write in different table Pin
Richard MacCutchan26-Dec-17 23:41
mveRichard MacCutchan26-Dec-17 23:41 
Rant[REPOST] Trigger value > ? write in different table Pin
Richard Deeming8-Jan-18 8:24
mveRichard Deeming8-Jan-18 8:24 
Questiondata between 1st jan to December 31st of previous year query --no hard coded dates. Pin
sai.201226-Dec-17 11:51
Membersai.201226-Dec-17 11:51 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Victor Nijegorodov26-Dec-17 23:06
MemberVictor Nijegorodov26-Dec-17 23:06 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Chris Quinn27-Dec-17 1:01
MemberChris Quinn27-Dec-17 1:01 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
jschell1-Jan-18 8:11
Memberjschell1-Jan-18 8:11 

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.