Primary key on two columns SQL Server

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024

ความคิดเห็น •

  • @GundakaMandaka
    @GundakaMandaka 3 ปีที่แล้ว +14

    8+ years you were uploading videos . Dedication and Explanation is pretty awesome. You are my Guru. Thank you very much @kudvenkat.

  • @kevinc5674
    @kevinc5674 3 ปีที่แล้ว +2

    you are the best on explaining sql DB! I like your voice loud and clear!!

  • @vikasverma93
    @vikasverma93 3 ปีที่แล้ว +3

    Dear sir, your videos clear all doubts..

  • @pramodmaurya6610
    @pramodmaurya6610 3 ปีที่แล้ว +2

    As always something new to learn from you...thanks a lot sir..

  • @venkatgandam3573
    @venkatgandam3573 3 ปีที่แล้ว +1

    Clearer cut explanation ..thank you Venkat

  • @TheusKhan
    @TheusKhan 3 ปีที่แล้ว +1

    Your video is so helpful and clear all doubts! Excellent, thanks.

  • @sephyent
    @sephyent ปีที่แล้ว

    Thank you for the explanation. I totally forgot this, after a long time not developing, My reference material are missing and google was not helping like after 1 hour i found this video. I guess its harder when you forgot and trying to specifically get the info you want then learning back all over again

  • @arunece100
    @arunece100 3 ปีที่แล้ว +1

    I really appreciate your effort for sharing knowledge and like it. But one suggestion when ever you start any series please complete that and start another series.

  • @Nicetrycutiepie
    @Nicetrycutiepie 3 ปีที่แล้ว +1

    Thanks for clear example Venkat.

  • @mohansaivelagapudi929
    @mohansaivelagapudi929 3 ปีที่แล้ว +10

    Mr kudvenkat please upload all Data science courses like R, Python, Hadoop.... Waiting for that from you

  • @TommiLipponen
    @TommiLipponen 3 ปีที่แล้ว +4

    This is a great piece on information, thank you Sir. Could you show at some point how to do a code first EF Core CRUD with similar composite key example like this one and UserId is ASP NET Identity GUID? I've tried it many times but always something goes wrong.

  • @shrutisahay216
    @shrutisahay216 3 ปีที่แล้ว

    Thank u for all your awesome videos

  • @clashclan4739
    @clashclan4739 ปีที่แล้ว

    how to composite foreign key and how composite primary key physically order and saved. how the lookup work for this table... i mean analysis of execution plan

  • @jatinsharma8166
    @jatinsharma8166 3 ปีที่แล้ว +4

    Hello sir, i haven't found any videos related power automate tool. So i insist you to please upload any video to make it more understandable. Thanks.

  • @ayyoubberoigui4553
    @ayyoubberoigui4553 2 ปีที่แล้ว

    thanks for your work !

  • @jalaluddin1753
    @jalaluddin1753 3 ปีที่แล้ว +1

    Please upload a video on populate value from one drop down list on another using foreign key constraints in mvc

  • @mhraamirali
    @mhraamirali 3 ปีที่แล้ว +15

    Sir please complete azure tutorial series. 🙂🙂

  • @ramanjaneyulu5118
    @ramanjaneyulu5118 3 ปีที่แล้ว +2

    Venkat sir Can you please start Course on React JS

  • @TheUjjwalpandey
    @TheUjjwalpandey 3 ปีที่แล้ว +1

    Hi venkat, recently an interviewer asked me to write a select query to select all the 3 values('a', 'b', null) from a column and replace the null value with 'c'. Can you please suggest the correct approach?

    • @annukumari9629
      @annukumari9629 3 ปีที่แล้ว +6

      I guess this should work..
      Select from table where column in ('a', 'b', coalesce(null, 'c'))

    • @TheUjjwalpandey
      @TheUjjwalpandey 3 ปีที่แล้ว +2

      @@annukumari9629 I answered same. But was not sure if it was right.

    • @simon-white
      @simon-white 3 ปีที่แล้ว +3

      @@annukumari9629 more like this:
      select coalesce(column, 'c') as OutputColumn from table where column in ('a', 'b') or column is null

    • @pramodwayal4207
      @pramodwayal4207 2 ปีที่แล้ว

      Select COALESCE(a,b,isnull('',c) from table

  • @singanasrinivas6580
    @singanasrinivas6580 2 ปีที่แล้ว

    Hi Venkat, Your videos are very helpful to me. Thanks for your time and the way of your explanation.
    I have a question here.
    In composite primary key, how the indexes work?
    Since there are two primary keys, two clustered indexes will be allowed ?

  • @KaliKali-cr4nf
    @KaliKali-cr4nf ปีที่แล้ว

    Still confused on composite pk 😕 you say no duplicate rows but on the Autors_book you had 1, 1 on both columns across the rows

  • @clashclan4739
    @clashclan4739 ปีที่แล้ว

    How is composite primary key physically stored in the database? Pls make a video like u already did for primary, heap table, rid lookup

  • @raven.4815
    @raven.4815 ปีที่แล้ว

    Thanks dude!

  • @nareshbuddy9522
    @nareshbuddy9522 3 ปีที่แล้ว +1

    @KudVenkat Hi Can you please explain on how to handle a scribbled Date format like '0002-03-21' to expected result '2021-03-2021' Can you please explain THank you in advance

  • @elfridhasman4181
    @elfridhasman4181 ปีที่แล้ว

    Thank You Very Muchhh :)

  • @hamzashehzad7273
    @hamzashehzad7273 ปีที่แล้ว

    Very nice teaching method

  • @archsana4481
    @archsana4481 3 ปีที่แล้ว

    Your translation area hide your codes... Unable to view your full code...

  • @vijaykounsalye
    @vijaykounsalye ปีที่แล้ว

    Superb❤

  • @sreenuksr
    @sreenuksr 3 ปีที่แล้ว +1

    Looking for react ja with.net. pls

  • @the_world_in_motion
    @the_world_in_motion ปีที่แล้ว

    Very helpful

  • @MohamedHassan-qp1bz
    @MohamedHassan-qp1bz 3 ปีที่แล้ว

    Thanks Venkat

  • @lovestudiochizu6021
    @lovestudiochizu6021 3 ปีที่แล้ว +1

    Awaiting more videos on azure .

  • @HiYoutuberLog
    @HiYoutuberLog 3 ปีที่แล้ว

    Thank you sir ji

  • @nashimbiswakarma
    @nashimbiswakarma 2 ปีที่แล้ว

    Thanks buddy

  • @abdulrashidsinancu1630
    @abdulrashidsinancu1630 ปีที่แล้ว

    Good One

  • @hmraja9665
    @hmraja9665 3 ปีที่แล้ว

    Could upload devops tutorial completely for beginners to professional

  • @sureshareti2843
    @sureshareti2843 3 ปีที่แล้ว +1

    Sir please do videos in power bi

  • @balakrishnapemmasani6490
    @balakrishnapemmasani6490 3 ปีที่แล้ว +1

    Please complete azure remaining concepts sir

  • @manukondasomeswarrao8904
    @manukondasomeswarrao8904 3 ปีที่แล้ว +1

    Hello kudvenkat please upload design patterns and solid principle.In your channel it is already there but I did not understand properly.Your explanation is awesome because of you I learned dot net.If possible please do videos on above that will be more helpful for us .

  • @CyberLibya
    @CyberLibya 5 หลายเดือนก่อน

    That's good

  • @KiyaniStrlk
    @KiyaniStrlk ปีที่แล้ว

    Need this with front end

  • @yaseenafzal6162
    @yaseenafzal6162 3 ปีที่แล้ว

    Upload progresive web app toutorials

  • @sikendongol4208
    @sikendongol4208 3 ปีที่แล้ว

    Composite Primary Key

  • @John_Noble
    @John_Noble 3 ปีที่แล้ว

    noticeable progress in English)