How transaction return True and False

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How transaction return True and False

Author

Topic

yaman
Posting Yak Master

213 Posts

Posted - 2008-06-10 : 02:44:34

Sir

I want to Return 1 and 0 after update , delete , Insert statement

IF Records Effected Return 1 else return 0

Pls help me out .........Sir

Yaman

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-10 : 02:54:54

IF @@ROWCOUNT > 0
RETURN 1
ELSE
RETURN 0

E 12°55'05.25"
N 56°04'39.16"

yaman
Posting Yak Master

213 Posts

Posted - 2008-06-10 : 03:06:45

I m already used Like This but this is always return 1 when record is update or not update

BEGIN TRY

DECLARE @TranName VARCHAR(20),@transaction varchar(50)
declare @name varchar(10)
SELECT @TranName = 'MyTransaction';
BEGIN TRANSACTION @TranName;
SAVE TRANSACTION SavepointName
UPDATE tbl_user
SET Groupid=@Groupid
WHERE Userid=@Userid And CompanyID=@CompanyID

Set @transaction=@@TRANCOUNT
Print @transaction
COMMIT TRANSACTION @TranName;
END TRY

BEGIN CATCH
IF @@TRANCOUNT > 0 and @@error<>0

rollback
END CATCH
End
IF @transaction > 0
Begin
Print 'A'
pRINT @transaction
Set @Return=1
End
Else
Begin
Set @Return=0
pRINT @transaction
Print 'B'
End

Yaman

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-10 : 03:11:27

No, you are using @@TRANCOUNT which is NOT the same as @@ROWCOUNT.

E 12°55'05.25"
N 56°04'39.16"

yaman
Posting Yak Master

213 Posts

Posted - 2008-06-10 : 03:21:21

Thank u Very Much Sir .

Sir then Where we used @@TRANCOUNT

Yaman

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources