Home Forums SQL Server 2014 Development - SQL Server 2014 CURSOR and TABLE RE: CURSOR and TABLE

  • October 18, 2013 at 2:22 pm

    #1659858

    T.Ashish (10/1/2013)

    Hi all,

    I consider CURSOR and TABLE as data types but some one has argued that these are database objects.

    Can you please share your views on the same !!

    Thanks.

    I agree with your terminology.

    For example,

    DECLARE some_name CURSOR FOR select_statement

    in my mind would create a variable called 'some_name' as type cursor, same with tables, with individual named cursors and tables as instances or "database objects" having those types.

    Not sure how excited I would be about having to convince someone about that who thinks otherwise, but its a bit satisfying for a language nerd like myself.