Creating table by variable name

Hi
How can i Create a table with variable name
eg
suppose variable x=tab1
I want the table created to be tab1 if x=tab2 then table created shd be tab2.. so how can this be dynamically done(creation of tables as well as stored procs)

i tried : create table @.x .. it doesnt seem to work
please help
regardssomething like...

CREATE PROCEDURE [dbo].[usp_CreateTable]

@.tablename varchar(200)

AS

sp_executesql('create table ' + @.tablename + ' column definations etc ')|||thanks.. Ill try this out :-)

Creating Fireign Keys....How?

Hi!!
How I can create foreign keys using Enterprise Manager without writing any
SQL commands'
Thanks in advance!
TimurHi,
Inside the table creation option from Enterprise manager, click the manage
relationship icon.
Thanks
Hari
MCDBA
"" <tim_@.pochtamt.ru> wrote in message
news:Oa3RUvY8DHA.2560@.TK2MSFTNGP09.phx.gbl...
> Hi!!
> How I can create foreign keys using Enterprise Manager without writing any
> SQL commands'
> Thanks in advance!
> Timur
>

Creating Extended Procedure using a COM DLL

Hi
How can we create an extened stored procedure using a COM DLL?
Thanks
LalitLalit,
this doesn't answer your question, but I'm wondering why you don't use the
sp_oa... procedures to instanciate the COM object directly. Please have a
look at this for more info:
http://msdn2.microsoft.com/en-us/library/aa172783(SQL.80).aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Creating Extended Procedure using a COM DLL

Hi
How can we create an extened stored procedure using a COM DLL?
Thanks
Lalit
Lalit,
this doesn't answer your question, but I'm wondering why you don't use the
sp_oa... procedures to instanciate the COM object directly. Please have a
look at this for more info:
http://msdn2.microsoft.com/en-us/library/aa172783(SQL.80).aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com