Code:
USE pubs
DECLARE @Query NVARCHAR(100)
DECLARE @table NVARCHAR(100)
SET @table = N'authors'
SET @Query = N'SELECT * FROM @tbl'
EXECUTE sp_executesql @Query, N'@tbl NVARCHAR(100)', @tbl=@table
USE pubs
DECLARE @Query NVARCHAR(100)
DECLARE @table NVARCHAR(100)
SET @table = N'authors'
SET @Query = N'SELECT * FROM @tbl'
EXECUTE sp_executesql @Query, N'@tbl NVARCHAR(100)', @tbl=@table
Hvala.