我们可以在另一个存储过程 - SQL Server中编写子函数或过程

I want to check if SQL Server(2000/05/08) has the ability to write a nested stored procedure, what I meant is - WRITING a Sub Function/procedure inside another stored procedure. NOT calling another SP. I want to check if SQL Server(2000/05/08) has t