Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 6,036 total)

  • RE: Using FileProperty function

    I don't think they gonna remove it from your copy of SQL Server.

  • RE: Using FileProperty function

    Use sp_MSforeachdb.

    Include 'USE ?' into the command string you execute.

  • RE: Bankers Rounding

    You'll see.

    Answer 1st question and you'll be answered on 2nd.

    Is it the rule respectful people follow?

  • RE: How to run a query in single user mode ?

    Do you have EM connected?

    Because it's single user connection you cannot have both applications connected.

    I tried this on my server and it worked.

  • RE: Creating Multiple indexes in one SQL statement

    > Is there a way to create all 3 at the same time running the query once?

    To create an index SQL Server needs to scan all values in the...

  • RE: Bankers Rounding

    I asked simple question:

    If the smallest interval you can measure is 1ps then "midnight event" is an event happened between 0:00:00.000.000.000.000 and 0:00:00.000.000.000.001(excl)

    If the smallest interval you can measure is...

  • RE: Bankers Rounding

    Lynn, I answered all questions.

    You're just too "minor in mathematics" to get it.

    So I was trying politely to repopulate you head with knowledge you missed in school and to reduce...

  • RE: how to improve performance of the query with unions

    I want to the screen where you gonna display that number of values simultaneously.

  • RE: Bankers Rounding

    OK, as I can see you've getting where you're wrong, so you're trying to skip off the conversation not to be brought to admittance of your error on public.

    That's the...

  • RE: Insert Week Number Field

    Add computed column.

  • RE: The T-SQL Quiz

    Igor,

    your test is still not correct.

    No, not true, it's still not complete.

    You forget - it's not a single user application, it's a server.

    So, open 10 windows in QA and...

  • RE: Bankers Rounding

    Lynn, as you could notice I'm not talking to you.

    You refused to continue with this discussion at least twice.

    It's not a style of discussion I could accept.

    So, shut up, please.

  • RE: Bankers Rounding

    So, your answer depends on precision you can measure time intervals.

    If the smallest interval you can measure is 1ps then "midnight event" is an event happened between 0:00:00.000.000.000.000 and 0:00:00.000.000.000.001(excl)

    If...

  • RE: Bankers Rounding

    David,

    1st, there is only one world.

    IT is a technology which suppose to reflect information about this world we have collected.

    > Exactly at midnight: A new day starts. Yes, even before...

  • RE: Need script to render list of all Tables, their columns, and their Datatypes

    Read about "INFORMATION_SCHEMA.COLUMNS view" in BOL.

Viewing 15 posts - 4,141 through 4,155 (of 6,036 total)