Click here to Skip to main content
15,919,479 members
Home / Discussions / Database
   

Database

 
GeneralRe: can we use sql reporting services with ASP3.0 Pin
Asif Sayed15-Jul-06 19:48
Asif Sayed15-Jul-06 19:48 
QuestionSUM() of a SUM() help please! [modified] Pin
Heinz_13-Jul-06 10:56
Heinz_13-Jul-06 10:56 
AnswerRe: SUM() of a SUM() help please! Pin
Ennis Ray Lynch, Jr.13-Jul-06 11:07
Ennis Ray Lynch, Jr.13-Jul-06 11:07 
GeneralRe: SUM() of a SUM() help please! Pin
Heinz_13-Jul-06 11:17
Heinz_13-Jul-06 11:17 
GeneralSQL Server has a table type Pin
Ennis Ray Lynch, Jr.13-Jul-06 11:21
Ennis Ray Lynch, Jr.13-Jul-06 11:21 
AnswerRe: SUM() of a SUM() help please! Pin
Mike Dimmick14-Jul-06 0:39
Mike Dimmick14-Jul-06 0:39 
GeneralRe: SUM() of a SUM() help please! Pin
Heinz_15-Jul-06 12:12
Heinz_15-Jul-06 12:12 
QuestionTransfer data between databases Pin
Gulfraz Khan13-Jul-06 4:54
Gulfraz Khan13-Jul-06 4:54 
I have two SQL server databases on the same server.
The table structure is same except for few.
I want to move some records from different tables one database to another.
What is the best way to do it?

create a DTS package, but I don't know how it supports 'Begin Tran' and the 'Execute SQL Task' in the DTS does not take any parameter (i.e. global variables) in the update and delete statements.

If I create a Stored procedure and use the 'Begin Tran' and 'Commit' statement in the procedure. It also does not work for me since the stored procedure keeps on executing the statements that are followed even if any error occurs (i.e. primary key violation etc.).
How do I make sure that the statements in the stored procedure are rolled back or procedure exits when any error occurs in it.

Thank you for helping me.



AnswerIf an error occurs Pin
Ennis Ray Lynch, Jr.13-Jul-06 9:22
Ennis Ray Lynch, Jr.13-Jul-06 9:22 
GeneralIt works for me! Pin
Gulfraz Khan14-Jul-06 4:19
Gulfraz Khan14-Jul-06 4:19 
QuestionMultiple user database Pin
codeamin13-Jul-06 4:51
codeamin13-Jul-06 4:51 
AnswerOpen the database as read/only Pin
Ennis Ray Lynch, Jr.13-Jul-06 9:18
Ennis Ray Lynch, Jr.13-Jul-06 9:18 
QuestionRecursive SELECT paradox!!! [modified] Pin
innocent7313-Jul-06 3:40
innocent7313-Jul-06 3:40 
AnswerRe: Recursive SELECT paradox!!! Pin
Eric Dahlvang13-Jul-06 4:13
Eric Dahlvang13-Jul-06 4:13 
GeneralRe: Recursive SELECT paradox!!! [modified] Pin
innocent7313-Jul-06 4:30
innocent7313-Jul-06 4:30 
GeneralRe: Recursive SELECT paradox!!! Pin
Eric Dahlvang13-Jul-06 4:37
Eric Dahlvang13-Jul-06 4:37 
GeneralRe: Recursive SELECT paradox!!! Pin
innocent7313-Jul-06 4:40
innocent7313-Jul-06 4:40 
GeneralThe best thing Pin
Ennis Ray Lynch, Jr.13-Jul-06 5:20
Ennis Ray Lynch, Jr.13-Jul-06 5:20 
GeneralRe: Recursive SELECT paradox!!! Pin
Eric Dahlvang13-Jul-06 5:50
Eric Dahlvang13-Jul-06 5:50 
QuestionSQL replication using .net Pin
farshad.A13-Jul-06 2:38
farshad.A13-Jul-06 2:38 
QuestionSQl file Log Pin
AnhTin12-Jul-06 18:13
AnhTin12-Jul-06 18:13 
AnswerRe: SQl file Log Pin
kumarprabhakar7412-Jul-06 18:37
kumarprabhakar7412-Jul-06 18:37 
GeneralRe: SQl file Log Pin
AnhTin12-Jul-06 18:59
AnhTin12-Jul-06 18:59 
GeneralRe: SQl file Log Pin
WoutL12-Jul-06 20:40
WoutL12-Jul-06 20:40 
AnswerRe: SQl file Log [modified] Pin
Mike Dimmick13-Jul-06 3:18
Mike Dimmick13-Jul-06 3:18 

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.