Database Reference
In-Depth Information
Figure 6-8.
Inserting rows via sqlcmd
Figure 6-9.
Viewing results via SSMS
As you can see, using the sqlcmd utility is straightforward. Just remember that it doesn't work with
SQL Azure if you're trying to use heap tables. All tables must have a primary key. Also, as mentioned
earlier, the
-z
and
-Z
parameters don't work.
This section has discussed the different mechanisms for connecting and querying SQL Azure,
including examples for ADO.NET, ODBC, and SqlCmd. You can see that it quite similar to the way you
currently connect to and query an on-premise database. However, with an overall industry push to an
SOA architecture, let's take the discussion to the next level and discuss using services, specifically WCF
Data Services, to connect to our Azure database.
