Query Differences in SQL Azure

Did you know that you can use USE? Or that SELECT INTO doesn't work? There are some definite differences between what we can do in the 'standard' SQL Server and what we can do in Azure. Nothing that can keeps us from getting work done, but seeing them here will reduce the learning curve and frustration level when you launch your first Azure project!

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...

Stuart Donnelly on 6/14/2010

Good quick intro...

Kasey Wheeler on 6/23/2010

Good video

Sara Karasik on 6/23/2010

why are all these wonderful features being dropped in SQL AZURE??

Ahmad Elayyan on 6/23/2010

What a SQL Server Version ???!!!! so they called it sql server ??!!!

CK Park on 6/24/2010

Very good

Don on 6/24/2010

Seems like SQL Azure is not yet ready for anything but the simplest of applications

Robert Nicholson on 6/26/2010

Shame about not having cross database queries. Not really too fussed on losing SELECT INTO and global temp tables. 5 minutes per connection what's with that? Obviously this shouldn't be a deal with end users but developers, analysts and admins may have difficulties with large datasets and query times.

Charlie Bruno on 6/26/2010

Another informative video on SQL Azure. Good work.