1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Rep Power

    Doubt declare SQLServer

    I'd like to know, if there is a possibility reference declare SQLServer dynamically?

    For example, I've tried execute this query(under), but I received this message (Server: Msg 137, Level 15, State 1, Line 6
    Must declare the variable '@t1'.):

    declare @Frase varchar(50)
    set @Frase = 'declare @t1 varchar(10), @t2 int'
    exec (@Frase)
    select @t1 = 'AAAAA'
    select @t2 = 1000
    Print @t1
    Print @t2

    I need to do this because 1) I get informations about specific table (sysobjects and syscolumns); 2) In relation to these columns I'll create a declare to use with a cursor, but unfortunately I can't.

  2. #2
  3. Digitally Challenged
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Rep Power
    why don't you just declare the variables instead of trying to exec a statement?
    My brain cells are like a storm trooper's armor: useless

IMN logo majestic logo threadwatch logo seochat tools logo