Sorry, es will einfach nicht.
Hier mal mein code.
CREATE PROCEDURE dbo.CreateDailyAuctionsTable
(
@TableName varchar(30)
)
AS
EXEC 'CREATE TABLE ' + @TableName +'(
[AuctionId] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[CategoryId] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[AuctionTitle] [varchar] (255) COLLATE Latin1_General_CI_AS NOT NULL
,
[BitFlag] [int] NULL ,
[StartTime] [datetime] NULL ,
[StartPrice] [money] NULL ,
[BidCount] [int] NULL ,
[CurrentPrice] [money] NULL ,
[BuyItNowPrice] [money] NULL ,
[EndTime] [datetime] NULL ,
[EndPrice] [money] NULL ,
[UpdateInProgress] [bit] NULL ,
[LastUpdate] [datetime] NOT NULL ,
CONSTRAINT [PK_Auctions] PRIMARY KEY CLUSTERED
(
[AuctionId],
[CategoryId]
) ON [PRIMARY] ,
CONSTRAINT [Categories_Auctions_FK1] FOREIGN KEY
(
[CategoryId]
) REFERENCES [Categories] (
[CategoryId]
)
) ON [PRIMARY]'
> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:coffeehouse-
> [EMAIL PROTECTED] Im Auftrag von Claudius Ceteras
> Gesendet: Montag, 10. M�rz 2003 15:42
> An: [EMAIL PROTECTED]
> Betreff: RE: [Coffeehouse] Tabelle mit variablen Tabellennamen erstellen
>
> >
> >
> > �h, ich glaub ich kann Dir nicht ganz folgen
> >
>
> Jepp... War ja auch unverst�ndlich ausgedr�ckt.. :-)
>
> Sowas meinte ich:
> EXECUTE 'CREATE TABLE ' + @TableName
>
> Claudius
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
> Kaffeepause im United Planet Communityserver ...
> http://www.intrexx.com/communityserver
> _______________________________________________
> Coffeehouse mailing list
> [EMAIL PROTECTED]
> http://www.glengamoi.com/mailman/listinfo/coffeehouse
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Kaffeepause im United Planet Communityserver ...
http://www.intrexx.com/communityserver
_______________________________________________
Coffeehouse mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/coffeehouse
