Opprette tabell, tabellnavnet skal hente variabel

declare @tlb varchar
set @tbl = 'TEST'

declare @SQL varchar

set @sql = 'create table [dbo].[' + @tbl + '] (DocID int identity(1,1) not null, ) on primary

execute @SQL

Den eneste måde, du kan gøre det på er at danne et dynamisk SQL script og udføre det via Execute.

Create table statementet understøtter ikke variable.

Er det ikke noen annen lettere måte å gjøre det på? Jeg har noen lange tabeller....

Feks bare lage første linje på nytt?

CREATE TABLE [dbo].[tblLanguage] (
    [LanguageID] [int] IDENTITY (1, 1) NOT NULL ,
    [Language] [varchar] (50) NOT NULL ,
    [LanguageFlag] [varchar] (6) NOT NULL ,
    [LanguageFKLocalID] [int] NOT NULL ,
    [LanguageLocaleID] [int] NOT NULL ,
    [LanguageTitle] [varchar] (140) NOT NULL ,
    [LanguageDescription] [varchar] (255) NOT NULL ,
    [LanguageFaktaWords] [varchar] (1000) NOT NULL ,
    [LanguageKeywords] [varchar] (200) NOT NULL ,
    [LanguageAdress] [varchar] (255) NOT NULL ,
    [LanguageDevelopedBy] [varchar] (30) NOT NULL ,
    [LanguagePrinterFriendly] [varchar] (50) NOT NULL ,
    [LanguageNoCases] [varchar] (30) NOT NULL ,
    [LanguageYesCases] [varchar] (30) NOT NULL ,
    [LanguageNews] [varchar] (30) NOT NULL ,
    [LanguageNoNews] [varchar] (30) NOT NULL ,
    [LanguageNewsReadMore] [varchar] (20) NOT NULL ,
    [LanguageFindAllNews] [varchar] (50) NOT NULL ,
    [LanguageSorryNoHits] [varchar] (30) NOT NULL ,
    [LanguageControllSpelling] [varchar] (50) NOT NULL ,
    [LanguageDownloads] [varchar] (30) NOT NULL ,
    [LanguageNoDownloads] [varchar] (30) NOT NULL ,
    [LanguageFindAllDownloads] [varchar] (50) NOT NULL ,
    [LanguageStats] [varchar] (30) NOT NULL ,
    [LanguageSince] [varchar] (10) NOT NULL ,
    [LanguageVisitToday] [varchar] (30) NOT NULL ,
    [LanguageTotalVisit] [varchar] (30) NOT NULL ,
    [LanguageOnline] [varchar] (30) NOT NULL ,
    [LanguageSearchWebsite] [varchar] (50) NOT NULL ,
    [LanguageSearchButton] [varchar] (15) NOT NULL ,
    [LanguageNewSearchButton] [varchar] (15) NOT NULL ,
    [LanguageSearchInDocuments] [varchar] (50) NOT NULL ,
    [LanguagePage] [varchar] (15) NOT NULL ,
    [LanguageOf] [varchar] (10) NOT NULL ,
    [LanguageNoOfHitsFound] [varchar] (50) NOT NULL ,
    [LanguageSearchResultFor] [varchar] (50) NOT NULL ,
    [LanguageCreated] [varchar] (15) NOT NULL ,
    [LanguageSearchInNews] [varchar] (50) NOT NULL ,
    [LanguageNext] [varchar] (15) NOT NULL ,
    [LanguageBack] [varchar] (15) NOT NULL ,
    [LanguageFilName] [varchar] (15) NOT NULL ,
    [LanguageOpen] [varchar] (15) NOT NULL ,
    [LanguageOpenAlt] [varchar] (50) NOT NULL ,
    [LanguageSave] [varchar] (15) NOT NULL ,
    [LanguageSaveAlt] [varchar] (50) NOT NULL ,
    [LanguageLastUpdated] [varchar] (30) NOT NULL ,
    [LanguageSize] [varchar] (15) NOT NULL ,
    [LanguageContactUS] [varchar] (30) NOT NULL ,
    [LanguageSMTP] [varchar] (50) NOT NULL ,
    [LanguageDomain] [varchar] (50) NOT NULL ,
    [LanguageErrorEmail] [varchar] (50) NOT NULL ,
    [LanguageContactEmail] [varchar] (50) NOT NULL ,
    [LanguageContactBack] [varchar] (50) NOT NULL ,
    [LanguageContactBack1] [varchar] (30) NOT NULL ,
    [LanguageContactBack2] [varchar] (30) NOT NULL ,
    [LanguageContactBack3] [varchar] (30) NOT NULL ,
    [LanguageContactBack4] [varchar] (30) NOT NULL ,
    [LanguagePerson] [varchar] (30) NOT NULL ,
    [LanguageFirm] [varchar] (30) NOT NULL ,
    [LanguageName] [varchar] (50) NOT NULL ,
    [LanguageEmail] [varchar] (50) NOT NULL ,
    [LanguageZip] [varchar] (30) NOT NULL ,
    [LanguageCity] [varchar] (30) NOT NULL ,
    [LanguagePAdress] [varchar] (30) NOT NULL ,
    [LanguagePhone] [varchar] (15) NOT NULL ,
    [LanguageMobile] [varchar] (15) NOT NULL ,
    [LanguageFax] [varchar] (15) NOT NULL ,
    [LanguageContactAbouttxt] [varchar] (50) NOT NULL ,
    [LanguageContactChoose] [varchar] (50) NOT NULL ,
    [LanguageContactAbout] [varchar] (50) NOT NULL ,
    [LanguageErrorName] [varchar] (30) NOT NULL ,
    [LanguageErrorMail] [varchar] (30) NOT NULL ,
    [LanguageErrorPhone] [varchar] (30) NOT NULL ,
    [LanguageContactSendt] [varchar] (30) NOT NULL ,
    [LanguageContactMailSendt] [varchar] (30) NOT NULL ,
    [LanguageContactMailSendtMsg] [varchar] (100) NOT NULL ,
    [LanguageContactMailNotSendt] [varchar] (50) NOT NULL ,
    [LanguageContactMailNotSendtMsg] [varchar] (100) NOT NULL ,
    [LanguageContactWindowClose] [varchar] (50) NOT NULL ,
    [LanguageRegards] [varchar] (30) NOT NULL ,
    [LanguageContact] [varchar] (50) NOT NULL ,
    [LanguageContact1] [varchar] (50) NOT NULL ,
    [LanguageContact2] [varchar] (50) NULL ,
    [LanguageContact3] [varchar] (50) NULL ,
    [LanguageContact4] [varchar] (50) NULL ,
    [LanguageContact5] [varchar] (50) NULL ,
    [LanguageContact6] [varchar] (50) NULL ,
    [LanguageContact7] [varchar] (50) NULL ,
    [LanguageContact8] [varchar] (50) NULL ,
    [LanguageContact9] [varchar] (50) NULL ,
    [LanguageContactErase] [varchar] (30) NOT NULL ,
    [LanguageContactSend] [varchar] (30) NOT NULL ,
    [LanguageContactConfirm] [varchar] (30) NOT NULL ,
    [LanguageFrontStats] [bit] NOT NULL ,
    [LanguageFrontNews] [bit] NOT NULL ,
    [LanguageFrontDownloads] [bit] NOT NULL ,
    [LanguageUpdated] [datetime] NOT NULL
) ON [PRIMARY]
GO

Ikke hvad jeg umiddelbart kan se.

Da kan jeg likeså godt lage det i asp.. Takk for hjelpen