SQL Server Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Category Archives: SQL Server

Use Web Browser along side SQL Query editor

Posted On April 22, 2021 by Jaison Menezes Posted in

Sometimes while writing SQL Queries we would feel the need to refer to the internet for logic, syntax etc. But constant switching between our web browser and SSMS would interrupt our flow while writing queries. This problem can be solved by using SSMS’s inbuilt web browser. It can be accessed pressing CTRL+ALT+R As you click … Continue reading Use Web Browser along side SQL Query editor

Share Story :

How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Introduction: Sometimes a user wants to analyze their SQL query results in Microsoft Excel or import existing Excel data sheets as tables in SQL in order to do various data transformations. In both scenarios we can achieve this goal as: Converting Data from SQL table to Excel sheet: Go to tools option on the toolbar … Continue reading How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Share Story :