Forum Replies Created

Viewing 15 posts - 166 through 180 (of 222 total)

  • RE: Independence Day

    I could have sworn the question asked which of these actors lived in Colorado...

    When I go back to it now, it is "who starred in Independence Day" ...

  • RE: ANY

    The whole point of "Any" is that it compares a value to a columnar set of values. The question wouldn't make any sense at all if the values were...

  • RE: ANY

    I have a different result:

    --Assuming that I have the following values in the TimeGroup table (value1, value2, value3, value4), what does this query return?

    CREATE TABLE #TimeGroup(column1 VARCHAR(50),column2 VARCHAR(50),column3 VARCHAR(50),column4 VARCHAR(50))

    INSERT...

  • RE: WAITFOR

    WAITFOR

    {

    DELAY 'time_to_pass'

    | TIME 'time_to_execute'

    | [ ( receive_statement ) | ( get_conversation_group_statement ) ]

    [ ,...

  • RE: Text Column Updates

    The most correct answer is "Change the column to data type varchar(max) and use Update

    This is the method I have used. UpdateText seems like another way around this.

  • RE: Text Column Updates

    Please see the article on how to update text files:

    http://www.sqlservercentral.com/articles/Advanced+Querying/manipulatingtextvariables/2066/

    Did I read it wrong? UpdateText seems to be the better answer although it looks like WriteText works...

  • RE: The Vacation Dilemma

    We all work too hard and deal with too much competition in this industry to safely say that it is okay to not get it done before we leave. ...

  • RE: A Hex on Your Database

    The wording of the question was awkward, no doubt about it. Sorry about that.

    Whoa - the whole question went shooting right over my head since first reading. No...

  • RE: A Hex on Your Database

    "THIS"

    There is an adjustable bar on my page - can anyone tell me how that was coded. I'm assuming when the question refers to "... this" that the meaning...

  • RE: Know your UNION(s), NULL(s), COUNT(s) ?

    I agree - great question!

  • RE: Installed Instances

    Sometimes we should have a easy qs like this to boost our points

    That was my thought a few weeks ago and so I wrote a couple of...

  • RE: Impersonation in an Execute As statement

    Thanks Simon. Makes sense now.

  • RE: Impersonation in an Execute As statement

    So then an individual who is a sysadmin logging in would not be impersonateing anything at the server level contrary to what I understand the reference above to mean.

    That's where...

  • RE: Impersonation in an Execute As statement

    If the statement is called by a member of sysadmin, server-level impersonation is used. If the statement is called by an account that is dbo, database-level impersonation is used.

    If...

  • RE: Delete Duplicates

    Of note, I learned something today as well regarding the semi-colons as my background is vb where semi-colons make our life more difficult. I am focussing on getting those...

Viewing 15 posts - 166 through 180 (of 222 total)