need stored procedure

microsoft.public.sqlserver.programming

12 Aug 2005 7:30 AM

DNKMCA

Hi,

my table : tab1

id int
name varchar(50)

i want to write a stored procedure that returns the max(id) from the table.
how to create it.

thanks in advance
dnk

12 Aug 2005 8:06 AM

Uri Dimant

Hi
Use MAX() function

Show quote

"DNKMCA" <d**@msn.com> wrote in message
news:exf%23s%23wnFHA.3564@tk2msftngp13.phx.gbl...
> Hi,
>
> my table : tab1
>
> id int
> name varchar(50)
>
> i want to write a stored procedure that returns the max(id) from the
> table.
> how to create it.
>
> thanks in advance
> dnk
>
>