is there something like subprocedure in TSQL ?

• daniel.danes

  SSC Rookie

  Points: 37

  More actions

  December 29, 2003 at 5:20 am

  #83621

  Hi,

  is there something like subprocedure (or GOTO) what could be used to reduce code duplications in stored procedures or triggers ?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 29, 2003 at 5:28 am

  #487920

  There is a GOTO command in T-SQL. It is explained in BOL. Also you'll find there

  a topic 'nesting stored procedures'

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• rschaeferhig

  SSCrazy Eights

  Points: 8776

  More actions

  December 30, 2003 at 6:30 am

  #488166

  Nested Stored Procedures or User Defined Functions (UDF's) are the best ways to modularize (?) code in TSQL.