Home Forums SQL Server 7,2000 T-SQL Execute a Stored procedure from different databases RE: Execute a Stored procedure from different databases

  • Another thing, you cannot use @t in the from clause if @t is not a table variable.

    If you are passing only the name, you need to build up your query using dynamic SQL

    declare @query varchar(1000)

    set @query = 'select * from ' + @a

    exec(@query)

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software