Forum Replies Created

Viewing 15 posts - 256 through 270 (of 716 total)

  • RE: Combining union and union all

    Neeraj Prasad Sharma (7/4/2013)


    did`t knew that, thanx for the question 🙂

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: VIEWS 2

    Very good question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: CREATE ROLE

    Straight forward.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: SSIS-Cache Transform

    Peter Trast (3/15/2012)


    Great question, never heard of cache transforms. Thanks!

    Same 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Policies

    Hard 1, had to google it.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: IsNumeric

    Eazy 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: The First Day

    SQLRNNR (1/2/2015)


    Happy New Year!

    Bonus for a good explanation.

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: The End

    I remember i have read about this somewhere, so bicked the correct answer, thanx 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    Geoscrewed (12/30/2014)


    Yet another way to cheat... and learn some new languages in the process 😀

    SELECT *

    FROM sys.messages

    WHERE message_id = 2714

    and language_id = 1033 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    t.pratiksha (12/30/2014)


    status is showing blue in Sql server 2012 :p

    As mentioned in the explanation, it`s not a reserverd word although showing as blue.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    Rich Weissler (12/30/2014)


    Hany Helmy (12/30/2014)


    Wow :w00t: 41% didn`t know about the "Extra comma in column list" will not prevent you from creating a table.

    I didn't. And after a few...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    Very nice tricky question for the OBJECT_ID('dbo.QoTD') 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    Wow :w00t: 41% didn`t know about the "Extra comma in column list" will not prevent you from creating a table.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Create Table FAILED!?

    Carlo Romagnano (12/30/2014)


    I googled "Msg 2714" and answered correctly.

    +1 Same 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Checking meta data

    Guessed it right 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 15 posts - 256 through 270 (of 716 total)