% PassThrough SqlServer sea-srv1 AdventureWorks2000 SSPI false Name SELECT ProductID, Name, ProductNumber, ListPrice FROM Product WHERE (ProductID >= @MinProductID) AND (ProductID <= @MaxProductID) AND (Name LIKE @Name) AND (ProductNumber LIKE @ProductNumber) Text Equals true 0 99999999 % % % % ID Name true Product Number true List Price SELECT ProductID FROM Product WHERE ProductID > 1200 AND ProductID < 1300 Text ID Sales Order SELECT SalesOrderID, OrderDate, SubTotal, IndividualID FROM SalesOrderHeader, Individual WHERE (SalesOrderID >= @MinSalesOrderID) AND (SalesOrderID <= @MaxSalesOrderID) AND (SalesOrderNumber LIKE @SalesOrderNumber) AND SalesOrderHeader.CustomerID = Individual.CustomerID Text Equals 0 99999999 % % ID Order Date true IndividualID true SubTotal true FirstName SELECT * FROM Individual WHERE (IndividualID >= @MinIndividualID) AND (IndividualID <= @MaxIndividualID) AND ((FirstName+' '+LastName) LIKE @Name) Text Equals 0 99999999 % % ID true true SELECT SalesOrderID, OrderDate, SubTotal,Individual.IndividualID FROM SalesOrderHeader,Individual WHERE SalesOrderHeader.CustomerID=Individual.CustomerID and Individual.IndividualID=@IndividualID Text ID Order Date true IndividualID true SubTotal true