Click here to Skip to main content
15,880,047 members
Home / Discussions / Database
   

Database

 
GeneralRe: Debugging a Stored Proc Pin
Mike Dimmick28-Oct-03 3:15
Mike Dimmick28-Oct-03 3:15 
GeneralRe: Debugging a Stored Proc Pin
Jörgen Sigvardsson30-Oct-03 9:33
Jörgen Sigvardsson30-Oct-03 9:33 
GeneralDataTable.Select Pin
Ryan_Roberts28-Oct-03 2:41
Ryan_Roberts28-Oct-03 2:41 
GeneralPlease point me in the right direction... Pin
frank2127-Oct-03 9:00
frank2127-Oct-03 9:00 
GeneralRe: Please point me in the right direction... Pin
Aryo Handono31-Oct-03 3:15
professionalAryo Handono31-Oct-03 3:15 
Generalconnection pooling Pin
yyf27-Oct-03 7:59
yyf27-Oct-03 7:59 
GeneralRe: connection pooling Pin
Jörgen Sigvardsson30-Oct-03 9:38
Jörgen Sigvardsson30-Oct-03 9:38 
GeneralProcess SQL Transactions?? Easy Question :) Pin
mittalpa27-Oct-03 6:41
mittalpa27-Oct-03 6:41 
Hi,

Environment - VB.NET, ASP.NET, SQL Server 2000.

In SQL 2000, I am sending an XML, which carries data for two tables. Let's say, I am inserting half of the fields in TABLE1 and rest in TABLE2.

Specifically, I want to use Transaction Processing for inserting the rows in both tables. If insertion in one table fails, any inserted data should ROLLBACK and come out of procedure with relevant error code.

Please advice or send me any example links. Thanks

Pankaj


Follow your goals, Means will follow you ---Gandhi---
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
Mike Dimmick28-Oct-03 2:13
Mike Dimmick28-Oct-03 2:13 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
mittalpa28-Oct-03 3:17
mittalpa28-Oct-03 3:17 
GeneralMemory Leak! Pin
Kevin Gutteridge27-Oct-03 0:36
Kevin Gutteridge27-Oct-03 0:36 
GeneralRe: Memory Leak! Pin
Mike Dimmick28-Oct-03 3:00
Mike Dimmick28-Oct-03 3:00 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:03
Kevin Gutteridge28-Oct-03 22:03 
GeneralRe: Memory Leak! Pin
Mike Osbahr28-Oct-03 3:38
Mike Osbahr28-Oct-03 3:38 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:47
Kevin Gutteridge28-Oct-03 22:47 
GeneralHi All Pin
Venkatraman26-Oct-03 13:55
Venkatraman26-Oct-03 13:55 
GeneralSQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 12:58
moredip26-Oct-03 12:58 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 13:14
Edbert P26-Oct-03 13:14 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 13:22
moredip26-Oct-03 13:22 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 

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.