SQL 存储过程调用另一个存储过程

Question

我就是想每一个dropdownlist控件调用一个存储过程，省哪里很好做，但后面就不行了
请问后面的市和区县要怎么做存储过程？

Answer 1

CREATE PROCEDURE Pro_address_shi
    @shen nvarchar(10)
AS
SELECT DISTINCT address_shi
  FROM T_address
 WHERE address_shen = @shen
GO

CREATE PROCEDURE Pro_address_qu
    @shen nvarchar(10),
    @shi nvarchar(10)
AS
SELECT address_qu
  FROM T_address
 WHERE address_shen = @shen
   AND address_shi = @shi
GO