CREATE PROCEDURE [dbo].[readVideoProc]
(
@totalcountpage int output
)
AS
set @totalcountpage=(select COUNT(ID) from tb_ShiTi )
在sql查询中，就可以赋值，为什么
set @tt=(select COUNT(ID) as ID from tb_ShiTi )
select @tt as tt
output sql
------解决方案--------------------
存储过程调用：
declare @i int
exec readVideoProc @i output
select @i