How to export data from SQL server to Excel | Export table records to Excel | SQL DBA

Поділитися
Вставка
  • Опубліковано 12 гру 2024

КОМЕНТАРІ • 31

  • @joshuajato3878
    @joshuajato3878 Рік тому +3

    Good video. Very easy to understand. Thank you.

  • @Vishnu_Lover
    @Vishnu_Lover 10 місяців тому +2

    Thanks Sir ❤❤

  • @Indiancultureinone
    @Indiancultureinone 2 роки тому +1

    Thank you BK sir

  • @Mohitkumar-fr3nn
    @Mohitkumar-fr3nn 11 місяців тому +1

    But in my sql server management studio there is no option of Sql server native client 11.0. What should I do?

  • @yvi.weiwei5882
    @yvi.weiwei5882 Рік тому +1

    I having error message the operation could not be completed login failed for user xxx(Microsoft sql server native client) may you suggest how to solve

  • @vishy161
    @vishy161 Рік тому +1

    Is there any way to do this via stored procs ?

  • @monkeyman00010
    @monkeyman00010 Рік тому

    TY SO MUCH SIR

  • @anantghorpade9496
    @anantghorpade9496 Рік тому

    excillent sir i tried but only headers of the colums copied can guide me please

  • @dineshbalu2038
    @dineshbalu2038 Рік тому

    but how to import mysql workbench could u please make a video

  • @anantghorpade9496
    @anantghorpade9496 Рік тому

    sir how generated the querry to see what is inside the table

  • @venkatasuryasaip5239
    @venkatasuryasaip5239 2 роки тому

    Hi sir will you please upload about blocking and deadlocks and Fragmentation and their troubleshooting and resolutions please

  • @amruthacv2432
    @amruthacv2432 8 місяців тому

    Sir what to do if Microsoft is not registered in local machine?

  • @amruthacv2432
    @amruthacv2432 9 місяців тому

    Sir if I were to make changes in the excel sheet will it reflect in the database?

    • @datboi6066
      @datboi6066 8 місяців тому +1

      no, it doesnt...youre exporting from sql nothing you do in excel affects sql

    • @amruthacv2432
      @amruthacv2432 8 місяців тому

      Do u by any chance know how to do it ?

  • @Abhibhojyan
    @Abhibhojyan 10 місяців тому

    if we want to export those data which we get after excute a command ,only want execute data

  • @bhavanikancharla3904
    @bhavanikancharla3904 2 роки тому

    Hi, Could you please explain hyper-v and cluster as well

    • @righttolearnbk
      @righttolearnbk  2 роки тому

      Sure.
      Please find videos in MS Sql playlist on Windows failover cluster service or click below links to watch
      ua-cam.com/video/Y5tz_70ktHc/v-deo.html
      ua-cam.com/video/IHzynh0CnpI/v-deo.html

    • @bhavanikancharla3904
      @bhavanikancharla3904 2 роки тому

      @@righttolearnbk Thank you so much for your response

  • @artisingh226
    @artisingh226 Рік тому

    I want to learn mssql. can you help

  • @sarahelen1877
    @sarahelen1877 9 місяців тому

    but that is with the wizard, ¿how can we export to Excel without SSIS nor the Wizard, but with SQL commands?

  • @RohitKumar-cg9ns
    @RohitKumar-cg9ns 7 місяців тому

    Plz tell how to import excel file qsl severe

  • @laileshm1183
    @laileshm1183 2 роки тому

    Copy paste bhi kr skte he na

    • @righttolearnbk
      @righttolearnbk  2 роки тому

      Yes, but copy paste will not work for large amount of data

    • @Abhibhojyan
      @Abhibhojyan 10 місяців тому

      headers copy ni honge

  • @man525
    @man525 Рік тому

    How to export 20 million rows

  • @panplusk9539
    @panplusk9539 2 роки тому

    Why not just copy paste? Takes 2 seconds instead of 5 minutes? ;)

    • @righttolearnbk
      @righttolearnbk  2 роки тому +1

      You can do it but there is also a limit for copy paste, if yiu have some million records you cannot do it

    • @panplusk9539
      @panplusk9539 2 роки тому

      @@righttolearnbk Havent thought about that, You're right. Thanks.

  • @anantghorpade9496
    @anantghorpade9496 Рік тому

    sir how can i contact you