AW: [Database.asp] AW: Probleme mit Variablen in T-SQL

[Dieter L�tje]

Nochmal Hallo Joachim,

also beim Drop krieg ich's hin. Aber beim Create verl��st mich noch. Hast Du
'ne Idee warum jetzt im Script das Create Database noch nicht l�uft?


 USE master

 DECLARE @DBS_Name     varchar(25)
 DECLARE @DBS_DataName varchar(25)
 DECLARE @DBS_LogName  varchar(25)
 DECLARE @DBS_Dir      varchar(520)

 SET @DBS_Name     = N'test'
 SET @DBS_DataName = @DBS_Name + N'data.mdf'
 SET @DBS_LogName  = @DBS_Name + N'_log.ldf'

 SELECT  @DBS_Dir = Substring(phyname, 1, CharIndex(N'master.mdf',
Lower(phyname)) - 1)
 FROM    master.dbo.sysdevices
 WHERE  (name = N'master')

 IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = @DBS_Name)
    EXEC('DROP DATABASE [' + @DBS_Name + ']')

 EXEC('CREATE DATABASE [' + @DBS_Name + ']' +
      '                 ON (NAME = ' + @DBS_DataName + ',' +
      '                     FILENAME = ' + @DBS_Dir + @DBS_DataName + ',' +
      '                     SIZE = 1,' +
      '                     FILEGROWTH = 10%)' +
      '        LOG      ON (NAME = ' + @DBS_LogName + ',' +
      '                     FILENAME = ' + @DBS_Dir + @DBS_LogName + ',' +
      '                     SIZE = 1,' +
      '                     FILEGROWTH = 10%)' +
      '        COLLATE Latin1_General_BIN')


mfg - dieter

> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Auftrag von Joachim Uersfeld
> Gesendet: Mittwoch, 30. Juli 2003 01:43
> An: [EMAIL PROTECTED]
> Betreff: [Database.asp] AW: Probleme mit Variablen in T-SQL
>
>
> > Was mach ich denn nun in den Zeilen 22, 24, 25 und 27 falsch ?
>
> Dinge wir DROP DATABASE und CREATE DATABASE funktionieren nur mit
> Variablen,
> wenn man sie in
> EXEC() setzt.
>
> z.B.: EXEC('DROP DATABASE ' + @DBS_DataName)
>
> Tsch��, Joachim
>
> _______________________________________________
> Database.asp mailing list
> [EMAIL PROTECTED]
> http://www.glengamoi.com/mailman/listinfo/database.asp
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.491 / Virus Database: 290 - Release Date: 18.06.2003
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18.06.2003


_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp