Pass Table Name as parameters

DECLARE @sql nvarchar(4000), @objName sysname, @Count int

SET @objName = 'CUSTOMER_DIM'

SET @sql = 'SELECT * FROM ' + @objName

EXEC @Count = sp_executesql