Click here to Skip to main content
15,947,785 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get the second occuring of a row Pin
SomeGuyThatIsMe30-Jun-08 8:39
SomeGuyThatIsMe30-Jun-08 8:39 
Questionconnecting to remote sql server Pin
kadkir30-Jun-08 3:48
kadkir30-Jun-08 3:48 
AnswerRe: connecting to remote sql server Pin
rrrriiizz2-Jul-08 19:37
rrrriiizz2-Jul-08 19:37 
QuestionSQL Server 2008 Express Pin
Brendan Vogt30-Jun-08 3:26
Brendan Vogt30-Jun-08 3:26 
AnswerRe: SQL Server 2008 Express Pin
Mark Salsbery30-Jun-08 7:01
Mark Salsbery30-Jun-08 7:01 
AnswerRe: SQL Server 2008 Express Pin
Paul Conrad30-Jun-08 7:05
professionalPaul Conrad30-Jun-08 7:05 
QuestionStored procedure = Unit of work? Pin
AliasElias30-Jun-08 2:00
AliasElias30-Jun-08 2:00 
AnswerRe: Stored procedure = Unit of work? Pin
Mike Dimmick30-Jun-08 3:05
Mike Dimmick30-Jun-08 3:05 
In SQL Server, each individual statement, whether executed as a single batch, as a statement within a batch, or within a stored procedure, is independent. If you need the ACID properties to apply over multiple statements, you need to create a transaction.

In a stored procedure this is easiest to do with the BEGIN TRANSACTION statement. Use COMMIT TRANSACTION when you're done, to keep the results, or ROLLBACK TRANSACTION to discard them. Be aware that the transaction is not automatically rolled back for non-fatal errors, that is, errors that do not abort the batch. You should check @@ERROR after each statement to check whether there was an error.


DoEvents: Generating unexpected recursion since 1991

GeneralRe: Stored procedure = Unit of work? Pin
AliasElias30-Jun-08 12:11
AliasElias30-Jun-08 12:11 
QuestionHow to monitor query in Pervasive.sql . Please help me it is very urgent for me Pin
Akash Agarwal29-Jun-08 23:59
Akash Agarwal29-Jun-08 23:59 
Questionselect count query(2 field) Pin
kabirkhan29-Jun-08 20:06
kabirkhan29-Jun-08 20:06 
AnswerRe: select count query(2 field) Pin
meeram39530-Jun-08 0:28
meeram39530-Jun-08 0:28 
AnswerRe: select count query(2 field) Pin
ChandraRam30-Jun-08 0:49
ChandraRam30-Jun-08 0:49 
QuestionGetting blank pages while exporting data into pdf format using SSRS 2005 Pin
prabhakaranns29-Jun-08 8:01
prabhakaranns29-Jun-08 8:01 
QuestionInserting into table from cursor Pin
iamdking28-Jun-08 21:41
iamdking28-Jun-08 21:41 
AnswerRe: Inserting into table from cursor Pin
Mycroft Holmes28-Jun-08 21:50
professionalMycroft Holmes28-Jun-08 21:50 
Question"Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 4:39
francoisdotnet28-Jun-08 4:39 
AnswerRe: "Stock Recon" type query .. most efficient route? Pin
Paul Conrad28-Jun-08 8:05
professionalPaul Conrad28-Jun-08 8:05 
GeneralRE: "Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 12:03
francoisdotnet28-Jun-08 12:03 
GeneralRe: RE: "Stock Recon" type query .. most efficient route? Pin
Paul Conrad28-Jun-08 12:32
professionalPaul Conrad28-Jun-08 12:32 
AnswerRe: "Stock Recon" type query .. most efficient route? Pin
Pete O'Hanlon28-Jun-08 10:57
mvePete O'Hanlon28-Jun-08 10:57 
GeneralRe: "Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 12:06
francoisdotnet28-Jun-08 12:06 
QuestionCount all posts added before or in a specific month Pin
Sunday8PM28-Jun-08 2:38
Sunday8PM28-Jun-08 2:38 
AnswerRe: Count all posts added before or in a specific month Pin
Paul Conrad28-Jun-08 8:08
professionalPaul Conrad28-Jun-08 8:08 
GeneralRe: Count all posts added before or in a specific month Pin
Sunday8PM28-Jun-08 9:06
Sunday8PM28-Jun-08 9:06 

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.