34,588
社区成员
发帖
与我相关
我的任务
分享
ALTER PROC sp_test
AS
BEGIN
SELECT_ALL:
SELECT * FROM item_ALL
END
go
DECLARE @i INT
SET @i=2;
IF @i=1
BEGIN
GOTO SELECT_ALL;
END
ELSE
GOTO SELECT_Single;
SELECT_Single:
SELECT TOP 1 * FROM MASTER.dbo.spt_values AS sv
GOTO theEND
SELECT_ALL:
SELECT TOP 1 * FROM MASTER.dbo.spt_values AS sv
theEND:
PRINT 'end'