How solve it??

• MC-142370

  Old Hand

  Points: 390

  More actions

  May 21, 2004 at 4:39 am

  #108311

  I have the following procedure. When i execute it it's giving me syntax error near '='. When I remove @count it works. So what's wrong with the syntax like this and how to solve it?? create PROCEDURE [dbo].[USP_GetFileCount] @tableName nvarchar(50),@colName nvarchar(50), @recordID int, @count int output AS exec( 'select ' + @count + ' = count(*) from '+ @tableName + 'where ' + @colName + ' = ' + @recordID)

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  May 21, 2004 at 4:58 am

  #507252

  You have to convert @Count to VARCHAR or CHAR

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  May 21, 2004 at 6:01 am

  #507258

  Try

  declare @sql nvarchar(100)

  set @sql = 'select @count = count(*) from ' +

  @tableName + ' where ' + @colName + ' = ' + CAST(@recordID as varchar)

  exec sp_executesql @sql,N'@count int output',@count output

  select @count

  Far away is close at hand in the images of elsewhere.
  Anon.