--use of output parameter in sql sever
create procedure contEmp
@count varchar(50) output
as
select @count=count(employee_id) from employee
-----------------------------
declare @count varchar(50)
exec contEmp @count output
select @count
-------------------------------------------
No comments:
Post a Comment