asp.net-SQL 存儲過程調用另一個存儲過程

SQL 存儲過程調用另一個存儲過程

我就是想每一個dropdownlist控件調用一個存儲過程，省哪裡很好做，但後面就不行了
請問後面的市和區縣要怎麼做存儲過程？

最佳回答：

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