Forum Replies Created

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

  • RE: Checking meta data

    Answer is incorrect:

    create function dbo.sp_test() returns int

    as

    begin

    return 1

    end

    go

    SELECT SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME + Char(13) + Char(10)

    From INFORMATION_SCHEMA.ROUTINES

    Where SPECIFIC_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI...

  • RE: Recovery Interval

    I hate when I'm in a rush, miss that the answers are checkboxes and only pick the first correct answer. Reading comprehension for the loss.

    Good question!

  • RE: Index Utilization Tending

    Mispost.

  • RE: many to many relationship

    Here's an example of a common many-to-many relationship.

    Assume we have many products, each which can be categorized in more than one category. Our primary keys are numeric IDs (ProductID...

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