Click here to Skip to main content
15,850,359 members
Home / Discussions / Database
   

Database

 
GeneralRe: BARCODE (Code39) Pin
OMalleyW1-Jul-05 2:55
OMalleyW1-Jul-05 2:55 
GeneralADO.NET - Best way to use the mighty SELECT Pin
BinaryHead22-Jun-05 4:53
BinaryHead22-Jun-05 4:53 
GeneralRe: ADO.NET - Best way to use the mighty SELECT Pin
Colin Angus Mackay22-Jun-05 7:03
Colin Angus Mackay22-Jun-05 7:03 
GeneralRe: ADO.NET - Best way to use the mighty SELECT Pin
david cohoon22-Jun-05 9:06
david cohoon22-Jun-05 9:06 
GeneralRe: ADO.NET - Best way to use the mighty SELECT Pin
BinaryHead22-Jun-05 23:25
BinaryHead22-Jun-05 23:25 
Generalreplication: remote login error Pin
NickKnife22-Jun-05 3:02
NickKnife22-Jun-05 3:02 
GeneralSQL Server 2000 CE Edition... Pin
Jan van den Baard22-Jun-05 2:54
professionalJan van den Baard22-Jun-05 2:54 
GeneralSQL SERVER 2005 INSTED OF Trigger Pin
Yaakov Davis22-Jun-05 2:28
Yaakov Davis22-Jun-05 2:28 
Hi.
I set an INSTED OF INSERT trigger on a table, that deny the addition of rows in some conditions.

My question is:
When I run the insert command, I get the (X row(s) affected) message, even if that isn't the real number of added rows.

I tried to set the @@ROWCOUNT function, but it turns out this isn't the way.
Is there any way to change the affected rows count of a trigger / sp?

Thanks,
Yaakov
GeneralSQL Server Manager 2005 animated wait thingie Pin
nxtwothou21-Jun-05 11:37
nxtwothou21-Jun-05 11:37 
GeneralConnection Pooling Pin
anju21-Jun-05 9:30
anju21-Jun-05 9:30 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 9:38
Colin Angus Mackay21-Jun-05 9:38 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 9:44
anju21-Jun-05 9:44 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 9:57
Colin Angus Mackay21-Jun-05 9:57 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 10:11
anju21-Jun-05 10:11 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 10:18
Colin Angus Mackay21-Jun-05 10:18 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 10:23
anju21-Jun-05 10:23 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 11:04
Colin Angus Mackay21-Jun-05 11:04 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 11:14
anju21-Jun-05 11:14 
GeneralRe: Connection Pooling Pin
Luis Alonso Ramos21-Jun-05 17:58
Luis Alonso Ramos21-Jun-05 17:58 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 21:25
Colin Angus Mackay21-Jun-05 21:25 
GeneralRe: Connection Pooling Pin
Mike Dimmick22-Jun-05 3:43
Mike Dimmick22-Jun-05 3:43 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay22-Jun-05 3:58
Colin Angus Mackay22-Jun-05 3:58 
GeneralRe: Connection Pooling Pin
Luis Alonso Ramos22-Jun-05 15:21
Luis Alonso Ramos22-Jun-05 15:21 
GeneralUsing Zip component to Zip files Pin
Wilbur J. Pereira21-Jun-05 3:56
Wilbur J. Pereira21-Jun-05 3:56 
GeneralRe: Using Zip component to Zip files Pin
Eduard Keilholz21-Jun-05 23:46
Eduard Keilholz21-Jun-05 23:46 

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.