T-Sql syntax for concatenating variables

• alfiee

  SSC Enthusiast

  Points: 165

  More actions

  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

   

   

   

   

• Bhushan

  Default port

  Points: 1427

  More actions

  July 5, 2006 at 11:17 am

  #647568

  Use Dymanic SQL Statement.

• alfiee

  SSC Enthusiast

  Points: 165

  More actions

  July 5, 2006 at 11:21 am

  #647571

  pls how do i use dynamic sql statement

• Julie Hargraves

  SSCarpal Tunnel

  Points: 4457

  More actions

  July 5, 2006 at 1:36 pm

  #647610

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

• alfiee

  SSC Enthusiast

  Points: 165

  More actions

  July 5, 2006 at 3:56 pm

  #647640

  Thanks