我正在尝试创建一个存储过程,该过程采用一个参数,如果一个列是真正的命令,另一个列是假订单.我该如何实现?
这是我到目前为止所拥有的@H_301_3@
CREATE PROCEDURE [dbo].[CLICK10_GetCP]
@switch AS BIT
AS
BEGIN
SELECT
acct_nbr,acct_name
FROM
acct
ORDER BY
END
GO
ORDER BY
CASE WHEN @switch = 0 THEN Field1 END,CASE WHEN @Switch = 1 THEN Field2 END
原文链接:https://www.f2er.com/mssql/76488.html