Forum Replies Created

Viewing 15 posts - 31 through 45 (of 257 total)

  • RE: Indexing in views

    Good question kapil.

    But if you execute this T-Sql in single batch, then it will give an error like "Procedure vw_customer, Line 9 Incorrect syntax near the keyword 'Create'."

    In...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 23, 2013 at 11:44 pm

    #1635200

  • RE: The OUTPUT clause and T-SQL Syntax

    Hugo Kornelis (7/23/2013)

    ...

    In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an INTO keyword....

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 23, 2013 at 7:13 am

    #1634932

  • RE: The OUTPUT clause and T-SQL Syntax

    Good question. I learn something new. 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 22, 2013 at 11:19 pm

    #1634754

  • RE: T-SQL

    Today's QtD is worthwhile.

    thanks hugo and kapil 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 22, 2013 at 7:00 am

    #1634448

  • RE: What's in a name?

    OCTom (7/19/2013)

    Wait?!?!? It's not Notepad?!?!?

    :w00t:

    Great one !!!

    :w00t::crazy::laugh::laugh::laugh:

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 19, 2013 at 7:06 am

    #1633999

  • RE: What's in a name?

    For see SSDTBI, you need to install SQL Server 2014 CTP. Remember that you can not install SQL Server 2014 CTP with other SQL server instance, or side by side...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 19, 2013 at 1:26 am

    #1633863

  • RE: TDE Setup

    Great knowledge sharing. reference article is also great.

    [https://www.simple-talk.com/sql/database-administration/transparent-data-encryption/]

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 17, 2013 at 11:29 pm

    #1633516

  • RE: Return

    Learn new thing. Thanks carlo 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 16, 2013 at 11:15 pm

    #1633072

  • RE: Reset of Identity

    Thanks for easy one 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 15, 2013 at 11:33 pm

    #1632755

  • RE: TSQL-Order by

    Danny Ocean (7/14/2013)

    kapil_kk (7/14/2013)

    When I checked the BOL i found that there is a line stating:

    If a table name is aliased in the FROM clause, only the alias name can...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 15, 2013 at 1:50 am

    #1632343

  • RE: TSQL-Order by

    kapil_kk (7/14/2013)

    When I checked the BOL i found that there is a line stating:

    If a table name is aliased in the FROM clause, only the alias name can be used...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 14, 2013 at 11:58 pm

    #1632299

  • RE: TSQL-Order by

    Thanks for start Monday with easy one 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 14, 2013 at 11:46 pm

    #1632298

  • RE: What will convert return?

    Good one. Actually whenever we try to convert any number data type (int, float, money, decimal,...) in Character format (char, varchar, nchar, nvarchar) and Character format length is less then...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 10, 2013 at 11:34 pm

    #1631463

  • RE: Change Tracking

    Good question and straightforward explanation 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 9, 2013 at 11:24 pm

    #1631064

  • RE: SQL Server 2012 Concat

    Quite easy, Really very good question. Still 36% people are wrong. It shows important of this question.

    Keep it up man !!! 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    July 8, 2013 at 11:38 pm

    #1630657

Viewing 15 posts - 31 through 45 (of 257 total)