Click here to Skip to main content
11,484,640 members (57,198 online)
   

Database

 
AnswerRe: Staging Area Pin
mark merrens16-Nov-12 9:34
membermark merrens16-Nov-12 9:34 
AnswerRe: Staging Area Pin
Mycroft Holmes16-Nov-12 16:20
memberMycroft Holmes16-Nov-12 16:20 
GeneralRe: Staging Area Pin
S Douglas27-Nov-12 20:38
memberS Douglas27-Nov-12 20:38 
GeneralRe: Staging Area Pin
Mycroft Holmes27-Nov-12 21:31
memberMycroft Holmes27-Nov-12 21:31 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 8:52
memberS Douglas29-Nov-12 8:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 2:02
memberMember 875182715-Nov-12 2:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 4:17
memberdigimanus15-Nov-12 4:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 8:40
membervanikanc14-Nov-12 8:40 
Hello All,

If I use a try-catch block in my stored proc, and in the catch block write error to table, do I need to use BEGIN TRANSACTION - COMMIT TRANSACTION to get the try-catch block to work?

I am using -
BEGIN TRY
write my code here
END TRY

BEGIN CATCH
write my code here
END CATCH

But should be - to write errors to a log table.
BEGIN TRY
BEGIN TRANSACTION
write code here
COMMIT TRANSACTION
END TRY
BEGIN CATCH
write code here
END CATCH
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 9:40
memberPhanindra26114-Nov-12 9:40 
QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 7:15
memberPhanindra26114-Nov-12 7:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 7:36
memberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 9:05
memberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 3:53
memberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 9:23
memberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 9:19
memberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 12:33
memberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 20:03
memberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 11:08
memberjschell12-Nov-12 11:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 13:51
memberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 19:40
memberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively [modified] Pin
Frygreen9-Nov-12 1:52
memberFrygreen9-Nov-12 1:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 3:32
memberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 5:08
memberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 5:10
memberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 9:00
memberMember 36227527-Nov-12 9:00 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 22 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid