@@rowcount returns null? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

@@rowcount returns null?

Message

De

30/04/2007 17:19:19

Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis

À

30/04/2007 17:18:32

Tc Holzer
Isle of Man

Information générale

Forum:

ASP.NET

Catégorie:

Autre

Titre:

Re: @@rowcount returns null?

Versions des environnements

Environment:

VB 8.0

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01221282

Message ID:

01221283

Vues:

9

>One app does an update, another app checks for the update using @@rowcount. Sometimes it returns a valid value, othertimes it returns null but I know an update was done by the other app and user. Any ideas?

Maybe it is a SET NOCOUNT ON/OFF setting?

Very fitting: http://xkcd.com/386/

Click here to load this message in the networking platform