Syntax errors

• Diyas

  SSCarpal Tunnel

  Points: 4845

  More actions

  July 25, 2017 at 1:03 pm

  #343770

  Hi,

  i am trying to execute below command but output is not getting .In my table year is 2017.
  can anyone help me

  SET @TableName = 'dbo.my_latestyear_ + CAST(@Year AS Varchar(4))_new'
      
      RETURN @TableName

  OutPut Come like --->my_latestyear_2017_new

  but output coming like  dbo.my__latestyear + CAST(@Year AS Varchar(4))_new

  please help me out.

• Luis Cazares

  SSC Guru

  Points: 183686

  More actions

  July 25, 2017 at 1:07 pm

  #1952664

  Sree Divya - Tuesday, July 25, 2017 1:03 PM

  Hi,

  i am trying to execute below command but output is not getting .In my table year is 2017.
  can anyone help me

  SET @TableName = 'dbo.my_latestyear_ + CAST(@Year AS Varchar(4))_new'
      
      RETURN @TableName

  OutPut Come like --->my_latestyear_2017_new

  but output coming like  dbo.my__latestyear + CAST(@Year AS Varchar(4))_new

  please help me out.

  You need to close the quotes before adding the year, instead of after.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Phil Parkin

  SSC Guru

  Points: 245813

  More actions

  July 25, 2017 at 1:08 pm

  #1952665

  SET @TableName = 'dbo.my_latestyear_' + CAST(@Year AS Varchar(4)) + '_new'

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• komal145

  SSCrazy Eights

  Points: 9892

  More actions

  July 25, 2017 at 1:27 pm

  #1952672

  Sree Divya - Tuesday, July 25, 2017 1:03 PM

  Hi,

  i am trying to execute below command but output is not getting .In my table year is 2017.
  can anyone help me

  SET @TableName = 'dbo.my_latestyear_ + CAST(@Year AS Varchar(4))_new'
      
      RETURN @TableName

  OutPut Come like --->my_latestyear_2017_new

  but output coming like  dbo.my__latestyear + CAST(@Year AS Varchar(4))_new

  please help me out.

  DECLARE @tablename varchar(100)
  ,@Year varchar(4)
  SET @Year='1994'
  SET @TableName = 'dbo.my_latestyear_'+ CAST(@Year AS Varchar(4))+'_new'

  print @TableName