Error converting data type varchar to numeric.

• • Reply

  12 years ago

  by yogeshkadvekar

  yogesh kadvekar

  , India

  Joined 14 years ago

  hi
  
  i m writting following code
  
  declare @i as numeric(18,0)
  declare @sql as varchar(8000)
  
  set @i =4
  
  set @sql ='select top '+@i+' * from dbo.tbl_ls_feed_data'
  exec(@sql)
  
  
  i mgetting error 

  to Error converting data type varchar to numeric. how to cast @i in this case

   

  Report abuse
• • Reply

  12 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  Because @sql is varchar, @i must also be varchar when constructing your dynamic sql string.

  The following should resolve your problem

  
  
  declare @i as numeric(18,0)
  declare @sql as varchar(8000)
  
  set @i =4
  
  set @sql ='select top '+ CAST(@i AS VARCHAR) + ' * from dbo.tbl_ls_feed_data'
  exec(@sql)
  

  Report abuse
• • Reply

  12 years ago

  by yogeshkadvekar

  yogesh kadvekar

  , India

  Joined 14 years ago

   thanks lot

  i did it  same way 

  Report abuse