Hi
What is the significant of () in the piece of code
RETURN (select count(*) from person)
When I remove the () from the above statement, it doesnot work and I get nothing
RETURN select count(*) from person
Here is the actual two sp
create PROCEDURE [dbo].[Person_SELECT_RecAccount]
@PersonID int,
@Country Nvarchar(50)
AS
BEGIN
SET NOCOUNT OFF;
select PersonID, fName,lName, dob, Sal,country, Active ,Photo
from Person where country = @Country
RETURN (select count(*) from person)-- this Works and I am getting record count.
END
create PROCEDURE [dbo].[Person_SELECT_RecAccount]
@PersonID int,
@Country Nvarchar(50)
AS
BEGIN
SET NOCOUNT OFF;
select PersonID, fName,lName, dob, Sal,country, Active ,Photo
from Person where country = @Country
RETURN select count(*) from person -- this did not work . I am not getting record counts
END
The GUI code to call this sp is >
...
Go to the complete details ...