Sybase set rowcount AND @@rowcount

set rowcount 1
SELECT Name FROM dbo.User

many commands will reset it to zero, you may have to select it into a local
declare @RowCnt int
select @RowCnt = @@rowcount
print "rowcnt %1!", @RowCnt