I have about 10 Tables(Table1 to Table10)
And then what i want is creat a Procedure like that:

CREATE PROCEDURE Pro1
 @TableIndex Int
AS
Case @TableIndex
  WHEN @TableIndex=1
SELECT * FROM Table1
 WHEN @TableIndex=2
SELECT * FROM Table2
 WHEN @TableIndex=3
SELECT * FROM Table3

And so on


Can anyone tell me What must i do ?

Thanks very much

EXEC('SELECT * FROM Table'+CAST(@TableIndex AS VARCHAR))

not much point having that in a stored procedure though

Thanks to pgtip
But your code does not work !
does any good idea !

sorry, try this variation instead
DECLARE @sql varchar(1024)
SET @sql='SELECT * FROM Table'+CAST(@TableIndex AS VARCHAR)
EXEC(@sql)

Thanks to pgtips very much !
your code work correctly . But If i have many table with diffirent name(not from table1 to table10) Then you use this script

CREATE PROCEDURE WhatTable

 @sql varchar(1024),
 @Tablename varchar(50)

AS
SET @sql='SELECT * FROM '+ @Tablename
EXEC(@sql)