Professional Web Applications Themes

USE variablename - Microsoft SQL / MS SQL Server

This cannot be run? Where's the problem? DECLARE DatabaseName varchar(10) SET DatabaseName = 'pubs' USE DatabaseName Thanks Ondra....

  1. #1

    Default USE variablename

    This cannot be run? Where's the problem?

    DECLARE DatabaseName varchar(10)
    SET DatabaseName = 'pubs'

    USE DatabaseName

    Thanks Ondra.



    Ondrej Guest

  2. #2

    Default Re: USE variablename

    That is how SQL Server work, quite simply. There are cases where SQL Server doesn't accept a
    variable. USE is one such case. Why do you need to do this? PErhaps we can suggest an altertative
    option...

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Ondrej Sevecek" <com> wrote in message news:OyM$phx.gbl... 


    Tibor Guest

  3. #3

    Default Re: USE variablename

    Ondrej
    Use it in this way
    DECLARE DatabaseName varchar(20)
    SET DatabaseName = 'pubs'
    exec('select * from '+ DatabaseName+'.dbo.titles')



    "Ondrej Sevecek" <com> wrote in message
    news:OyM$phx.gbl... 


    Uri Guest

Similar Threads

  1. call for object variable returns Array[0]->variableName
    By Fredo Vincentis in forum PHP Development
    Replies: 1
    Last Post: December 13th, 11:39 AM

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