September 10th, 2003, 05:31 PM
Join Date: Sep 2003
Time spent in forums: < 1 sec
Reputation Power: 0
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'
select @t1 = 'AAAAA'
select @t2 = 1000
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.