

CREATE PROCEDURE dbo.get_count
(
@SQL nVARCHAR(4000),

@count int output
)
AS


EXEC sp_ExecuteSql @SQL


set @count=@@ROWCOUNT
GO
