Click here to Skip to main content
12,512,130 members (57,385 online)
   

Database

 
QuestionStaging Area Pin
Phanindra26115-Nov-12 9:05
memberPhanindra26115-Nov-12 9:05 
AnswerRe: Staging Area Pin
mark merrens15-Nov-12 9:37
membermark merrens15-Nov-12 9:37 
GeneralRe: Staging Area Pin
Phanindra26116-Nov-12 0:14
memberPhanindra26116-Nov-12 0:14 
GeneralRe: Staging Area Pin
mark merrens16-Nov-12 7:58
membermark merrens16-Nov-12 7:58 
QuestionRe: Staging Area Pin
Phanindra26116-Nov-12 8:11
memberPhanindra26116-Nov-12 8:11 
AnswerRe: Staging Area Pin
mark merrens16-Nov-12 8:34
membermark merrens16-Nov-12 8:34 
AnswerRe: Staging Area Pin
Mycroft Holmes16-Nov-12 15:20
memberMycroft Holmes16-Nov-12 15:20 
GeneralRe: Staging Area Pin
S Douglas27-Nov-12 19:38
memberS Douglas27-Nov-12 19:38 
GeneralRe: Staging Area Pin
Mycroft Holmes27-Nov-12 20:31
memberMycroft Holmes27-Nov-12 20:31 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 7:52
memberS Douglas29-Nov-12 7:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 1:02
memberMember 875182715-Nov-12 1:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 3:17
memberdigimanus15-Nov-12 3:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 7:40
membervanikanc14-Nov-12 7:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 8:40
memberPhanindra26114-Nov-12 8:40 
no you do not have to(but it is a safer option)..Have a look at the following snippet..-

USE AdventureWorks2008R2;
GO
 
-- Variable to store ErrorLogID value of the row
-- inserted in the ErrorLog table by uspLogError
DECLARE @ErrorLogID INT;
 
BEGIN TRY
    BEGIN TRANSACTION;
 
    -- A FOREIGN KEY constraint exists on this table. This
    -- statement will generate a constraint violation error.
    DELETE FROM Production.Product
        WHERE ProductID = 980;
 
    -- If the delete operation succeeds, commit the transaction.
    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
    -- Call procedure to print error information.
    EXECUTE dbo.uspPrintError;
 
    -- Roll back any active or uncommittable transactions before
    -- inserting information in the ErrorLog.
    IF XACT_STATE() <> 0
    BEGIN
        ROLLBACK TRANSACTION;
    END
 
    EXECUTE dbo.uspLogError @ErrorLogID = @ErrorLogID OUTPUT;
END CATCH;
 
-- Retrieve logged error information.
SELECT * FROM dbo.ErrorLog WHERE ErrorLogID = @ErrorLogID;
GO

QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 6:15
memberPhanindra26114-Nov-12 6:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 6:36
memberEddy Vluggen14-Nov-12 6:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 8:05
memberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 2:53
memberYBG13-Nov-12 2:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 8:23
memberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 8:19
memberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 11:33
memberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 19:03
memberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 10:08
memberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 12:51
memberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 18:40
memberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 2:32
memberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 4:08
memberMycroft Holmes9-Nov-12 4:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 4:10
memberFrygreen9-Nov-12 4:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 8:00
memberMember 36227527-Nov-12 8:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 11:27
memberMycroft Holmes7-Nov-12 11:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 8:56
memberjschell8-Nov-12 8:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 10:03
membermehdi_nassiri00986-Nov-12 10:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 10:22
memberJörgen Andersson6-Nov-12 10:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 20:09
memberJoy Sinha22-Nov-12 20:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 6:25
memberM.T.H.Danish6-Nov-12 6:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 7:28
mvpRichard MacCutchan6-Nov-12 7:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 9:18
memberEddy Vluggen6-Nov-12 9:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 6:11
memberM.T.H.Danish6-Nov-12 6:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 6:27
memberihoecken6-Nov-12 6:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 2:49
memberM.T.H.Danish6-Nov-12 2:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 3:27
memberDavid Mujica6-Nov-12 3:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 3:31
memberJ4amieC6-Nov-12 3:31 
AnswerRe: SQL SERVER 2008 Pin
djj556-Nov-12 4:43
memberdjj556-Nov-12 4:43 
AnswerRe: SQL SERVER 2008 PinPopular
Michael Potter6-Nov-12 4:47
memberMichael Potter6-Nov-12 4:47 
GeneralAwesome solution Pin
David Mujica6-Nov-12 8:39
memberDavid Mujica6-Nov-12 8:39 
GeneralRe: Awesome solution Pin
Srini Sydney14-Nov-12 11:24
memberSrini Sydney14-Nov-12 11:24 
GeneralRe: SQL SERVER 2008 Pin
Mycroft Holmes6-Nov-12 12:11
memberMycroft Holmes6-Nov-12 12:11 
GeneralRe: SQL SERVER 2008 Pin
Michael Potter7-Nov-12 5:23
memberMichael Potter7-Nov-12 5:23 
SuggestionRe: SQL SERVER 2008 Pin
Eddy Vluggen7-Nov-12 5:47
memberEddy Vluggen7-Nov-12 5:47 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160929.1 | Last Updated 1 Oct 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid