Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLSailor.com

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (http://www.expedia.com/), having IT experience of more than 9 years. Anup is an active blogger with SQLSailor.com, and can also be found on MSDN SQLServer forums and BeyondRelational.com. He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure

In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.

This post is in continuation with my earlier 3 posts

SQLSailor is exploring(Part1) – Creating my first SQL Database on Windows Azure

SQLSailor is exploring(Part 2) – Managing SQL Databases on Windows Azure

SQLSailor is exploring(Part3) – Designing SQL Databases on Windows Azure

For the purpose of this demo we will use a database named SQLDatabase and Table dbo.Employee.

There is already some data which is entered for this table. Using Desgin view and under Data column we can see these details.

The best part of the portal I liked is it gives a clear tree like structure of my activities and the object hierarchy is also shown pretty neat.

We can write a simple SELECT statement using the New Query option to retrieve the data.

If you run with Actual Execution plan, then the query plan details are also made available.

There are 3 options to view the Query plans and they are -

Graph, Grid and Tree

Now we will quickly do a simple DELETE statement for one of the rows. Once delete is completed we can go back to Table view under My Work and see if changes are reflected (Refresh is required).

It’s pretty easy to create your own scripts and Open them in the design view of the portal and create your objects and relations.

Conclusion

We quickly looked at simple DML and DDL operations within a SQLDatabase and for a complete list of supported TSQL Statements for Windows Azure SQL Database you can bookmark the below link.

Supported Transact-SQL Statements (Windows Azure SQL Database)

There is more exciting stuff lined up, so keep checking this space !

Thanks for reading.


Comments

Leave a comment on the original post [sqlsailor.com, opens in a new window]

Loading comments...