Parametrizzare Tabella su cui fare SELECT

CREATE PROCEDURE [dbo].[Articoli]
  @Gestionale as Integer
AS

USE tempdb;
GO

CREATE PROCEDURE dbo.up_SelectIF(
@SelectID int = 1
)
AS
IF @SelectID = 1
    SELECT TOP 10 AddressID, AddressLine1
    FROM AdventureWorks.Person.Address

ELSE IF @SelectID = 2
    SELECT TOP 10 FirstName, LastName
    FROM AdventureWorks.Person.Contact
GO

EXEC dbo.up_SelectIF 1;

/* Output:

AddressID   AddressLine1
----------- -------------------------------
532         #500-75 O'Connor Street
497         #9900 2700 Production Way
29781       00, rue Saint-Lazare
24231       02, place de Fontenoy
19637       035, boulevard du Montparnasse
15671       081, boulevard du Montparnasse
13079       081, boulevard du Montparnasse
21354       084, boulevard du Montparnasse
910         1 Corporate Center Drive
322         1 Mt. Dell Drive

(10 row(s) affected)

*/

EXEC dbo.up_SelectIF 2;

/* Output:

FirstName    LastName
------------ -------------
Gustavo      Achong
Catherine    Abel
Kim          Abercrombie
Humberto     Acevedo
Pilar        Ackerman
Frances      Adams
Margaret     Smith
Carla        Adams
Jay          Adams
Ronald       Adina

(10 row(s) affected)

*/

DROP PROCEDURE dbo.up_SelectIF;
GO