Help for this pls stored procedure

[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 ?

[Michel Posseth [MCP]]

Re: Help for this pls stored procedure


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=C OUNT(*) FROM clients

wil do what you want

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

HTH

Michel Posseth [MCP]



"sebastien1 101" <sebastien1101@ hotmail.fr> schreef in bericht
news:1145267519 .630906.189410@ v46g2000cwv.goo glegroups.com.. .[color=blue]
> In my stored procedure i have :
> EXECUTE ('select ' + @TotalRecords + ' = count(*) from clients')
>
> It doesn't work!
> and i don't know how i can ?
>[/color]