Forum Replies Created

Viewing 15 posts - 91 through 105 (of 148 total)

  • RE: Query Plan Execution Order

    I answered anything because I know nothing about the execution plan but I wanted to see the answer and read the discussion now, so I tried something... and got...

  • RE: Spatial Data Types

    Jan Van der Eecken (10/26/2011)


    Unhm, what am I missing here? According to MSDN, "A LineString is a one-dimensional object representing a sequence of points and the line segments connecting them.",...

  • RE: Inserted Identity

    Very good question indeed!

    Took me a while to understand the "OUTPUT inserted.id" until I modified the query and finaly realised that the ".id" from the "OUTPUT inserted.id" was...

  • RE: Truncate and Delete

    Nils Gustav Stråbø (8/22/2011)


    Logging in this context is not about logins or permissions, it's about write operations that gets logged in the transaction log. Two completely different things.

    oye!:ermm:

    That means there...

  • RE: Truncate and Delete

    I have a question: how can you execute a T-SQL command if you are not logged

    or maybe a better way to address the question would be : What "is...

  • RE: Unicode Compression

    cengland0 (7/28/2011)


    Whoops, I go this one wrong because I accidentally selected a third option even though it said select two. ...

    Don't worry, you are not the only one...:Whistling:

    Thanks for...

  • RE: SQL Server Agent job information

    Ninja's_RGR'us (7/28/2011)]


    tilew-948340 (7/27/2011)


    You are lucky people with good brain... I am smart, but not as 'brained' as you guys. So take the points and let it be. I...

  • RE: merge, with or else?

    stewartc-708166 (7/28/2011)


    You could also have used CASE AND IS NULL, e.g.

    SET AllComments = CASE WHEN AllComments IS NULL THEN ST.AllComments ELSE AllComments + ', ' + ST.AllComments END

    There is a...

  • RE: SQL Server Agent job information

    jason.stephens (7/27/2011)


    People of all skill levels visit this site. So, an easy question for one person might not be for some others. That one was easy for me but what...

  • RE: merge, with or else?

    Geniiius (7/27/2011)


    What you really need is an aggregate function that does string concatenation. You can build one in CLR and use it like you would use SUM or AVG.

    I...

  • RE: merge, with or else?

    tfifield (7/27/2011)


    Try adding Comment to the GROUP BY clause:

    GROUP BY Target_ID, Comment

    Todd Fifield

    Change nothing on the error message from the merge...

    Thanks for trying to help me!

  • RE: PBM Alert

    "PolciyAdministrator is not a role in the msdb database"

    Almost half of the people thought it was a role :w00t:

    So very good question! Thanks!

  • RE: Login Properties

    J DBA (7/21/2011)


    Tx, I'd still like a 2k5 confirmation... am I the only one with a retarded server??? Can't possibly be the case

    I get NULL on both 2005...

  • RE: Bad Passwords

    I also try the command before (from the time I got SQLserver, I certainly logged once with a bad password!) and after doing a new login with a bad password....

  • RE: Money and Decimal Datatypes

    Got it wrong :doze:

    I tought the default scale on decimal would be 2

    Should have take time to verify...

    Good question, Thanks!

Viewing 15 posts - 91 through 105 (of 148 total)