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

Answer 2

省级联动很好做啊，如果是存储过程 根据关键字查一下就行了。

Answer 3

晕，一个存储过程就好了，增加参数，然后通过参数来去读需要的数据，没有对应参数就不加上
create procedure readdata
@pro nvarchar(50)=null,
@city nvarchar(50)=null,
@area nvarchar(50)=null
as
if @pro is null select * from xxx
else select * from xxx where pro=@pro
.......