SQL Server Performance

Table Data Type

Discussion in 'T-SQL Performance Tuning for Developers' started by CSharpFriends, Nov 7, 2002.

  1. CSharpFriends New Member

    Whenever we create a variable of type table, are permissions/rights created for this table?

    Basically what I am asking is if the data type 'table' under goes all the overhead of creating a regular table. Obviously this is not the case as it would be very slow in camparison to its current speed...Just curious to know all the details regarding this.


    ~webmaster
    http://www.csharpfriends.com
    CSharpFriends, Nov 7, 2002
    #2

  2. satya Moderator

    Its purely depends on the privileges of the table where you create this variable.

    Satya SKJ
    satya, Nov 8, 2002
    #2

  3. burbakei New Member

    if other users have EXECUTE permission on the functionn they can use the function.
    but if your function create a real table (sorry for the term real) or alter them they must have REFERENCES permission to the function.
    burbakei, Nov 16, 2002
    #2

Share This Page