Forum Replies Created

Viewing 15 posts - 136 through 150 (of 188 total)

  • RE: Master Keys

    SQLRNNR (5/29/2012)

    Thanks for the question.

    I tried to create more than one but it is not possible, so i answered 1 and got it correct..

    Even after reading the reference , I'm...

    January 9, 2013 at 4:05 am

    #1575144

  • RE: SQL JOINS

    Andre Ranieri (1/8/2013)

    Nice question - I wonder if the question category should have been table aliases instead of joins 🙂

    Thanks,

    Andre Ranieri

    +1

    January 8, 2013 at 11:07 pm

    #1575067

  • RE: INTERSECT 1

    Easy One..

    January 8, 2013 at 6:47 am

    #1574792

  • RE: INTERSECT 2

    Nice One.. Can anyone tell y we are not using Intersect. we always prefering JOINs.

    January 8, 2013 at 6:45 am

    #1574789

  • RE: CS Collation

    After reading all the 45 posts. I came to a conclusion that we shuld not dig much deeper into basics.. Really breaking head..

    Just for fun..

    Hugo u r always great..

    January 8, 2013 at 6:08 am

    #1574780

  • RE: Stairway to T-SQL DML Level 6: The Basics of Joining Tables and Record Sets

    Dineshbabu (1/8/2013)

    Often i will get an error stating, Columns used in ORder By was not listed in SELECT. Can anyone xplain when situtation arises..

    Sorry I got the answer in the...

    January 8, 2013 at 5:50 am

    #1574774

  • RE: Stairway to T-SQL DML Level 6: The Basics of Joining Tables and Record Sets

    Often i will get an error stating, Columns used in ORder By was not listed in SELECT. Can anyone xplain when situtation arises..

    January 8, 2013 at 5:48 am

    #1574773

  • RE: Coalesce and Conversion

    still now i thought COALESCE will return the datatype of Non NUll value. Today only i learnt it will consider the highest percedence..

    Thanks to author for posting nice qstn..

    January 8, 2013 at 12:13 am

    #1574628

  • RE: LIKE a vowel

    Hugo Kornelis (1/7/2013)

    Dineshbabu (1/7/2013)

    simply I selected one to see the explaination and understand the qstn. Really i didn't understand what the qstn is delaing abt...

    Can anyone xplain in detail. If...

    January 7, 2013 at 5:44 am

    #1574271

  • RE: T-SQL Syntax

    Nice one..

    January 7, 2013 at 5:15 am

    #1574267

  • RE: Nanoseconds

    Difficult one..

    January 7, 2013 at 5:04 am

    #1574264

  • RE: SEQUENCE

    I learnt two features of SQL server 2012.

    Thanks man..

    January 7, 2013 at 4:51 am

    #1574260

  • RE: LIKE a vowel

    simply I selected one to see the explaination and understand the qstn. Really i didn't understand what the qstn is delaing abt...

    Can anyone xplain in detail. If already xplained pls...

    January 7, 2013 at 4:28 am

    #1574250

  • RE: RANK - 1

    I don't have adventureworks DB, I answered by keeping the basic diff b/w RANK and DENSE_RANK and got it correct.

    Thanks for remebering the basics...

    January 7, 2013 at 4:09 am

    #1574245

  • RE: T-SQL

    Lynn Pettis (1/4/2013)

    L' Eomot Inversé (1/4/2013)

    Dineshbabu (1/3/2013)

    I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter...

    January 6, 2013 at 11:06 pm

    #1574166

Viewing 15 posts - 136 through 150 (of 188 total)