[Original] Number of affected rows returned after the stored procedure is executed

In the recent project, "Return (INT) cmd. Parameters [returnvalue]. value;" returns 0 every time. I think it is strange that there is a value after SQL query? I suddenly thought that store procedure does not return a value, so every time it is 0, after online query, I learned Rowcount It is used to obtain the number of records executed last time. That's exactly what I want! Complete Code As follows:

Create   Proc Pr_isexistloginname
(
@ Loginname   Varchar ( 30 )
)
As
Select   [ Loginname ]   From   [ Personlogin ]   Where   [ Loginname ] = @ Loginname
Return   @ Rowcount

Keywords: execution of stored procedures, number of rows, rowcount, returnvalue