你好象丢了个,号这样写看看
create proc c_authors
@mcity varchar(40),
@mcountry varchar(40)
as
select * from authors where city=@mcity
select * from authors where country=@mcountry
create proc c_authors
@mcity varchar(40),
@mcountry varchar(40)
as
select * from authors where city=@mcity
select * from authors where country=@mcountry
@mcity varchar(40),
@mcountry varchar(40)
as
select * from authors where city=@mcity and country=@mcountry