Help for this pls stored procedure

  • Thread starter Thread starter sebastien1101
  • Start date Start date
S

sebastien1101

In my stored procedure i have :
EXECUTE ('select ' + @TotalRecords + ' = count(*) from clients')

It doesn't work!
and i don't know how i can ?
 
No this doesn`t work :-)

as with a execute statement you are now creating the following string to
execute 'select = count(*) from clients'
so it will result in an error

if it is so that the stored procedure itself should return this value then

SELECT COUNT(*) FROM clients should do the trick

if it is your intention that the variabel @TotalRecords should hold the
value then

SELECT @TotalRecords=COUNT(*) FROM clients

wil do what you want

you may also perform anny select query and then read the @@ROWCOUNT value

HTH

Michel Posseth [MCP]
 
Back
Top