Syntax errors

• Diyas

  SSCarpal Tunnel

  Points: 4851

  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: 183706

  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: 246978

  More actions

  July 25, 2017 at 1:08 pm

  #1952665

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

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• komal145

  SSCrazy Eights

  Points: 9918

  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