Home Forums SQL Server 2008 SQL Server 2008 - General How Many type of Function in SQL Server ? RE: How Many type of Function in SQL Server ?

  • July 19, 2012 at 11:43 am

    #1515061

    ok, so my answer is D. Seven function types. Final Answer.

    (...waiting for the failure buzzer.....)

    my thinking is there are the Built in functions plus these six others.

    AF = Aggregate function (CLR) AGGREGATE_FUNCTION

    FS = Assembly (CLR) scalar-function CLR_SCALAR_FUNCTION

    FT = Assembly (CLR) table-valued function CLR_TABLE_VALUED_FUNCTION

    IF = SQL inline table-valued function SQL_INLINE_TABLE_VALUED_FUNCTION

    FN = SQL scalar function SQL_SCALAR_FUNCTION

    TF = SQL table-valued-function SQL_TABLE_VALUED_FUNCTION

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!