how to use danymic sql in SQL Server 2000

如何在T-SQL使用动态表名

declare @a nvarchar(1000)
set @a='test11'
set @a=N'create table '+@a+' ( a int) '
exec sp_executesql @a

另一种:
declare @a nvarchar(1000)
set @a='customer'
set @a='select * from '+@a
exec (@a)