Post reply

T-Sql syntax for concatenating variables

  • July 5, 2006 at 10:58 am

    #169458

    Hello all,

    I need to concatenate external arguments to an execute statement. Need the right syntax

    e.g

    declare @server varchar (30)

    declare @db varchar(30)

    exec [@server].[@db].[dbo].spu_procedure @remoteserver = @localServer output

    this statement gives me errors.

    Pls help

     

     

     

     

  • July 5, 2006 at 11:17 am

    #647568

    Use Dymanic SQL Statement.

  • July 5, 2006 at 11:21 am

    #647571

    pls how do i use dynamic sql statement

  • July 5, 2006 at 1:36 pm

    #647610

    exec ('[' + @server + '].[' + @db + '].[dbo].spu_procedure ' + @remoteserver + ' = ' + @localServer + ' output')

  • July 5, 2006 at 3:56 pm

    #647640

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply