Databases Reference
In-Depth Information
The Messages tab after executing this query is shown in the following screenshot:
3.
We may not need all columns of the
Sales.SalesOrderDetail
table in the
result set. So we may like to control the number of columns in the
SELECT
query
by specifying the proper column name with the query shown next:
SELECT
CarrierTrackingNumber
,OrderQty
,ProductID
,SpecialOfferID
,UnitPrice
FROM
Sales.SalesOrderDetail
WHERE
SalesOrderID>50000 and OrderQty>1
The following screenshot shows the result of this query:
Search WWH ::
Custom Search