Forum Replies Created

Viewing 15 posts - 121 through 135 (of 257 total)

  • RE: SQL Server Error Handling

    chgn01 (4/1/2013)

    I found this option in SQL 2020 SP4

    But i found this in sql server 007 SP 00.001 :-D:-D:-D

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

    April 1, 2013 at 10:59 pm

    #1602663

  • RE: TRY...CATCH

    Good one. New thing come to know.

    Thank. Keep it up !!! 🙂

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

    April 1, 2013 at 10:58 pm

    #1602662

  • RE: SQL Server Error Handling

    Easy question 😀 and lots of points.:w00t:

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

    March 31, 2013 at 11:12 pm

    #1602376

  • RE: Copy Multiple objects from One Schema to Another Schema

    Hi Arju,

    Sorry for reply to0 late. Please check the below link. this will help you.

    http://www.sqlservercentral.com/scripts/T-SQL/97571/

    I have also create different kind of scripts related to copy objects from one schema...

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

    March 28, 2013 at 11:34 pm

    #1601939

  • RE: LEN()

    Easy question, But unfortunately i selected wrong in hurry. :pinch:

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

    March 28, 2013 at 11:25 pm

    #1601937

  • RE: CASCADE - 2

    Good one Ron 🙂

    I think you have posted two questions on this topic earlier. If it is possible, then please post more questions on this topics with different kind of...

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

    March 27, 2013 at 11:31 pm

    #1601452

  • RE: Database Mirroring

    +1 🙂

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

    March 27, 2013 at 11:25 pm

    #1601451

  • RE: Passing Tables as Parameters

    Very good question !!! 🙂

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

    March 23, 2013 at 7:36 pm

    #1600093

  • RE: Deterministic

    Hi,

    Sorry, but i am unable to understand question completely.:ermm:

    If you increase varchar length then it will give right answer. Please try below T-sql statements

    SELECT CONVERT(VARCHAR,GETDATE(),20)

    SELECT CONVERT(VARCHAR,GETDATE(),21)

    SELECT CONVERT(VARCHAR,GETDATE(),106)

    SELECT CONVERT(VARCHAR,GETDATE(),107)

    SELECT CONVERT(VARCHAR,GETDATE(),109)

    SELECT CONVERT(VARCHAR,GETDATE(),113)

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

    March 21, 2013 at 11:15 pm

    #1599668

  • RE: Delete v Truncate

    Dineshbabu (3/20/2013)

    Thanks for recalling the basics.

    Still I have question, why it has been called as DDL command?

    I think due to different behavior of truncate command, it's consider as DDL...

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

    March 20, 2013 at 11:19 pm

    #1599227

  • RE: CASCADE - 1

    demonfox (3/20/2013)

    Danny Ocean (3/20/2013)

    Good question.

    In real life scenario, we need to take care of cascade option.

    I prefer not to have delete cascade on design .. to let the error display...

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

    March 20, 2013 at 12:31 am

    #1598733

  • RE: CASCADE - 1

    Good question.

    In real life scenario, we need to take care of cascade option.

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

    March 20, 2013 at 12:00 am

    #1598724

  • RE: Full-Text Search – Thesaurus Languages

    +1 🙂

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

    March 18, 2013 at 11:25 pm

    #1598290

  • RE: DATETIME - 4

    kapil_kk (3/17/2013)

    very good question to start of the week.. 😛

    :-):-):-)

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

    March 17, 2013 at 11:31 pm

    #1597962

  • RE: Casting question

    kapil_kk (3/15/2013)

    Danny Ocean (3/15/2013)

    Really a nice and good question.

    one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as...

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

    March 15, 2013 at 4:08 am

    #1597408

Viewing 15 posts - 121 through 135 (of 257 total)