Create PROCEDURE B
@S Nvarchar(100),
@Type int
AS
DECLARE @Where Nvarchar(100),@SELECT Nvarchar(300) SET @Where=N''
IF(@Type=0)
BEGIN
SET @WHERE=@WHERE+
N'
Order BY '+@S+' ASC
'
END
ELSE
BEGIN
SET @WHERE=@WHERE+
N'
Order BY '+@S+' DESC
'
END
SET @Select=
N'
SELECT S.*
FROM Student S
'
SET @SELECT=@SELECT+@Where
EXEC sp_executesql @SELECT,N'@Type int,@Where Nvarchar(100),@S Nvarchar(100)',@Type,@Where,@S
@S Nvarchar(100),
@Type int
AS
DECLARE @Where Nvarchar(100),@SELECT Nvarchar(300) SET @Where=N''
IF(@Type=0)
BEGIN
SET @WHERE=@WHERE+
N'
Order BY '+@S+' ASC
'
END
ELSE
BEGIN
SET @WHERE=@WHERE+
N'
Order BY '+@S+' DESC
'
END
SET @Select=
N'
SELECT S.*
FROM Student S
'
SET @SELECT=@SELECT+@Where
EXEC sp_executesql @SELECT,N'@Type int,@Where Nvarchar(100),@S Nvarchar(100)',@Type,@Where,@S
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货