Post reply

SP Group Number

  • August 12, 2002 at 10:21 pm

    #105249

    Does anyone know how do I determine the last number used within a set of a group of stored procedures?

    For example, I have created the following Stored procedures:

    mySP;1

    mySp;2

    mySp;3

    mySp;4

    How do I determine that for the mySP procedure, there are 4 stored procedures within it?

    Thanks in advance

    Billy

  • August 13, 2002 at 12:24 am

    #434471

    You can use the following statement.

    select max(number) from sysobjects o, syscomments c where o.name = 'mySP' and o.id = c.id

  • August 13, 2002 at 1:08 am

    #434473

    thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply