Professional Web Applications Themes

Strange problem with delimited identifiers - Microsoft SQL / MS SQL Server

Hi, I am using SQL Server 2000 (8.00.194) Personel Edition (it came with Office XP Developer) for an Access 2002 Project development. Recently in my MSDN subscription I rcvd and installed Visio for Arch. and used it to reverse eng my database. I then used the gen option to gen a DDL script. The script that was gened uses double quotes (") to delimit object identifiers as in: create table "case" ( "client" int not null, "case_num" char(15) not null) ON 'PRIMARY' go However, when I try to execute this from isql it says "syntax error near 'case'". If I ...

  1. #1

    Default Strange problem with delimited identifiers

    Hi,

    I am using SQL Server 2000 (8.00.194) Personel Edition
    (it came with Office XP Developer) for an Access 2002
    Project development. Recently in my MSDN subscription I
    rcvd and installed Visio for Arch. and used it to reverse
    eng my database. I then used the gen option to gen a DDL
    script. The script that was gened uses double quotes (")
    to delimit object identifiers as in:
    create table "case" (
    "client" int not null,
    "case_num" char(15) not null) ON 'PRIMARY'
    go
    However, when I try to execute this from isql it
    says "syntax error near 'case'". If I replace all the
    double quotes with brackets ([]) then it works fine.

    I don't have a problem with replacing the quotes with
    brackets. However, that makes it a pain to use the Visio
    tools AND the SQL Server doentation says that
    identifiers can be delimited with either brackets or
    double quotes. I can't find anywhere where a distinction
    is made between the two types of delimiters.

    If anyone has any insight into this problem, I would
    really appreciate receiving it.

    Thanks,
    Bob

    Bob Noll Guest

  2. #2

    Default Re: Strange problem with delimited identifiers

    Perhaps the QUOTED_IDENTIFIER setting on your SQL Server is set to OFF. You
    can try either preceding your query with the following command and then
    executing it in the isql tool:

    SET QUOTED_IDENTIFIER ON

    Alternatively, you can right-click and select Properties on the database in
    Enterprise Manager, go to the options tab and in the lower right quadrant of
    the dialog box check "Use quoted identifiers"

    Hope that helps!

    richard

    "Bob Noll" <robert.nollaletassoftware.com> wrote in message
    news:05a701c345b2$e2fc32e0$a501280aphx.gbl...
    > Hi,
    >
    > I am using SQL Server 2000 (8.00.194) Personel Edition
    > (it came with Office XP Developer) for an Access 2002
    > Project development. Recently in my MSDN subscription I
    > rcvd and installed Visio for Arch. and used it to reverse
    > eng my database. I then used the gen option to gen a DDL
    > script. The script that was gened uses double quotes (")
    > to delimit object identifiers as in:
    > create table "case" (
    > "client" int not null,
    > "case_num" char(15) not null) ON 'PRIMARY'
    > go
    > However, when I try to execute this from isql it
    > says "syntax error near 'case'". If I replace all the
    > double quotes with brackets ([]) then it works fine.
    >
    > I don't have a problem with replacing the quotes with
    > brackets. However, that makes it a pain to use the Visio
    > tools AND the SQL Server doentation says that
    > identifiers can be delimited with either brackets or
    > double quotes. I can't find anywhere where a distinction
    > is made between the two types of delimiters.
    >
    > If anyone has any insight into this problem, I would
    > really appreciate receiving it.
    >
    > Thanks,
    > Bob
    >

    Richard Propst Guest

Similar Threads

  1. Strange ARP Problem
    By Jon Simmons in forum Windows Server
    Replies: 1
    Last Post: June 30th, 03:29 PM
  2. comma delimited list problem
    By Shaun Perry in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: February 16th, 12:09 PM
  3. tab delimited file processing problem
    By Domenico Discepola in forum PERL Miscellaneous
    Replies: 5
    Last Post: July 18th, 07:58 PM
  4. Using Identifiers as Parameters in SQL server
    By DDDL in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 9th, 04:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139