I have a web app in azure which let user to input some data. I want to save them in sql db which I created in azure. Is there a way to check/view the entered data . I am referring to something like "mysql workbench for mysql"
Select your DB and then "Query editor" in the menu and start querying. Show activity on this post. You can download sql server management studio to access your data. Also you can you Visual Studio Community Edition or Visual Code.
Right-click the Products table in SQL Server Object Explorer, and select View Data. The Data Editor launches. Notice the rows we added to the table in previous procedures. Right-click the Fruits table in SQL Server Object Explorer, and select View Data.
Get view properties by using Object ExplorerIn Object Explorer, select the plus sign next to the database that contains the view to which you want to view the properties, and then click the plus sign to expand the Views folder. Right-click the view of which you want to view the properties and select Properties.
YES ,The code proves that the Azure SQL supports automatic use of indexed views without specifying the NOEXPAND hint.
You can download sql server management studio to access your data. Also you can you Visual Studio Community Edition or Visual Code.
Below is the link for download
http://go.microsoft.com/fwlink/?LinkID=828615
you also need to configure the sql database firewall to get access to your database. A Step by Step tutorial to configure that can be found in the following URL
https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
You may also view the data in your browser using Azure Portal
Select your DB and then "Query editor" in the menu and start querying.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With