By using syntax highlighting and error indicating, writing scripts is a breeze and the editor is useful for simple database CRUD (Create, Read, Update and Delete) operations.īefore executing any database, you must connect to a database by logging in with either your SQL Server or Azure Active Directory credentials. Many common queries can be run in the editor and you have flexibility to run partial or batch queries.
But it’s a great option to have and if you’re familiar with writing queries in SSMS, you’ll feel comfortable writing queries in the in-browser Query Editor. The Query Editor can’t take the place of SSMS, nor is it a competitor. SQL Database Query Editor can be a lifesaver in situations where you’re asked to solve a problem, but SQL Server Management Studio (SSMS) is not installed on a nearby computer. The biggest advantage of the Query Editor is that we can execute queries without having to leave the portal itself. The SQL Database Query Editor allows us to access Azure databases and execute queries using a browser, which is a handy tool for simple database operations in the Azure Portal. Here I’ll teach you how it is possible to execute queries in the Azure Portal when we don’t have access to SQL Server Management Studio (SSMS). One feature in the Azure Portal is the SQL Database Query Editor.
Azure offers many features and services, so if you’re new to Azure and the Azure Portal there is a lot to learn.
0 kommentar(er)
