Post reply

Owner prefacing table variable

  • October 13, 2004 at 1:08 am

    #165131

    Hello,

    Can i preface a variable of type "table" with owner name. For example [dbo].[@TableVariable]?? If yes, does it effect performance in any way or is it a good practice ??

    Regards,

    Hatim Ali.

  • October 13, 2004 at 5:46 am

    #526491

    I dont think you can, and I dont think it will affect performance either way.  Table variables (unless they get large) reside in memory and are always for the scope of the stored procedure only.  They get treated the same as other variables.

    Hope this helped



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • October 14, 2004 at 4:38 am

    #526681

    Thanks AJ

     

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

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