62,046
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE QX
{
@district NVARCHAR(50),
@num int
}
AS
BEGIN
if @num=1
BEGIN
SELECT * FROM [tbAppli_Info] WHERE district = @district order by [appliNum] ASC
END
ELSE
if @num=2
BEGIN
SELECT * FROM [tbAppli_Info] WHERE district = @district order by [total] ASC
END
END