Forum Replies Created

Viewing 15 posts - 481 through 495 (of 821 total)

  • RE: SSMS Error Message

    SQLRNNR (5/26/2013)


    Easy enough - I have done this in the past.

    +1

    In 80's, on mainfraim I placed the prompt with:

    "ADVANCED COBOL '85. COMPILING SOURCE ... SGCONT.CBL"

    So, it seemed an everending...

  • RE: Event Notification on Server

    It's easy, all services of microsoft store data in msdb (that stands for "microsoft database").

  • RE: Data Type

    I use this command SELECT INTO to create a table in development environment, then

    I use my personal EXEC sp_createtable 'TempTab' to generate the script for creating the table

    and in the...

  • RE: Timestamps

    The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

    +1

    😀

    Good qotd, but too...

  • RE: Identity Insert

    Danny Ocean (5/2/2013)


    Most of people don't know about it because it's not in use in any real scenario. I never use this kind of table in production environment, But i...

  • RE: Table Alias

    Rune Bivrin (5/2/2013)


    Hugo Kornelis (5/2/2013)


    However, to do some nitpicking:

    1. If I were to try this code on my system, I would get five errors. All system table (*) names are...

  • RE: Table Alias

    I like explanation!

    😀

  • RE: REPLICATE - 1

    crussell-931424 (5/1/2013)


    Hugo Kornelis (5/1/2013)


    Raghavendra Mudugal (5/1/2013)


    sorry; I have hard time in understanding/realizing the missing piece here.

    - Replicate is replicating as needed (the expression is 5 chars and and @s-2...

  • RE: Nested triggers 1

    What is the difference between the answer 3 and 6?

    5, 3, 1

  • RE: Nested triggers 1

    Bad question! Too much stuff, no value!

    It's take too long to check all the script!

  • RE: The Elusive Conditional WHERE Clause

    Knut Boehnert (4/18/2013)


    Carlo Romagnano (4/18/2013)


    Old stuff!

    Dynamic sql will run better.

    Sorry, all you are saying is that a red sky is always better than a green sky. But not why.

    Everyone knows...

  • RE: The Elusive Conditional WHERE Clause

    Old stuff!

    Dynamic sql will run better.

  • RE: Row Constructor

    A simple CROSS JOIN!

    🙂

  • RE: SQL JOINS

    Very easy!

  • RE: Endpoints

    sfayer (4/12/2013)


    kapil_kk (4/12/2013)


    AS per the explanation:

    "You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."

    When...

Viewing 15 posts - 481 through 495 (of 821 total)