Forum Replies Created

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

  • RE: recursive stored procedure: has a cursor

    From Books On line:  The syntax for declaring a cursor is: 

    Transact-SQL Extended Syntax

    DECLARE cursor_name CURSOR

    [ LOCAL | GLOBAL ]

    [ FORWARD_ONLY | SCROLL ]

    [ STATIC |...

  • RE: get a list of similar strings

    First I would recomend cleaning out "extra" chars like ".,-:;" etc.  Secondly I would remove any common parts of company names or at the very least make sure that they...

  • RE: Updates which don''''t participate in a transaction.

    Try Using a Table Variable:

    Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources....

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