About the Easysoft ODBC-Sybase Driver

SELECT * FROM Customers

-- Which different sales regions are there?
SELECT DISTINCT Region AS Different_Regions FROM SalesOrders
-- How many different sales regions are there?
SELECT COUNT(DISTINCT Region) AS Different_Regions FROM SalesOrders

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region = 'Eastern'

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region = 'Eastern'
  OR Region = 'Western'

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region = 'Eastern'
  AND {fn YEAR(OrderDate)} = 2024

cursor.execute("SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region = ?", ['Eastern'])

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  NOT Region = 'Eastern'

SELECT
  *
FROM
  SalesOrders
ORDER BY
  OrderDate ASC

SELECT
  *
FROM
  Contacts
ORDER BY
  (
    CASE
      WHEN Surname IS NULL THEN Title
      ELSE Surname
    END
  );

SELECT
    COUNT(Id) As "Number",
    ProductID
FROM
    SalesOrderItems
GROUP BY
    ProductID

SELECT
    COUNT(Id) As "Number",
    ProductID
FROM
    SalesOrderItems
GROUP BY
    ProductID
HAVING
  COUNT(Id) > 100;

SELECT Max(Quantity) FROM SalesOrderItems
SELECT Sum(Quantity) FROM SalesOrderItems

SELECT CAST(Quantity AS Char(100))FROM  SalesOrderItems
SELECT {fn CONVERT(Quantity, SQL_CHAR)} FROM SalesOrderItems

SELECT ProductID FROM SalesOrderItems WHERE Quantity BETWEEN 10 AND 20

SELECT City FROM Contacts
UNION
SELECT City FROM Customers
ORDER BY City;

SELECT SalesOrders.ID, Customers.Surname, SalesOrders.OrderDate
FROM SalesOrders
INNER JOIN Customers ON SalesOrders.CustomerID=Customers.ID;

SELECT Surname, GivenName FROM Customers WHERE CompanyName LIKE 'R%'
SELECT Surname, GivenName FROM Customers WHERE CompanyName LIKE '_he'

SELECT * FROM Customers WHERE CompanyName IS NULL

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region = 'Eastern'
  OR Region = 'Western'
  OR Region = 'Central'

SELECT
  OrderDate,
  SalesRepresentative
FROM
  SalesOrders
WHERE
  Region IN  ('Eastern', 'Western', 'Central')

SELECT TOP 10 * FROM Customers

SELECT
  Name
FROM
  Products
WHERE
  EXISTS (
    SELECT
     *
    FROM
      SalesOrderItems
    WHERE
     Products.ID = SalesOrderItems.ProductID
      AND Quantity < 20
  )

INSERT INTO
    Customers (
        Surname,
        GivenName,
        City,
        State,
        Country
    )
VALUES
    (
        'Devlin',
        'Michaels',
        'Kingston',
        'NJ',
        'USA'
    )

DECLARE
  num_rows integer;
BEGIN
num_rows:=DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@SybaseLink
('INSERT INTO Customers (Surname, GivenName, City, State, Country) VALUES (''Devlin'', ''Michaels'', ''Kingston'', ''NJ'', ''USA'')');
END;
/

my $sth = $dbh->prepare(q/INSERT INTO Customers (Surname, GivenName, City, State, Country) VALUES (?, ?, ?, ?, ?)/)
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('Devlin', 'Michaels', 'Kingston', 'NJ', 'USA');

UPDATE Customers
SET
  Surname = 'Jones'
WHERE
  Account_Id = '667'

my $sth = $dbh->prepare('UPDATE Customers SET Surname = \'Jones\' WHERE ID = ?')
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('667');

-- Delete (mark inactive) a bank account
DELETE FROM Customers WHERE ID = '667'

sql = "DELETE FROM Customers WHERE ID = ?"
cursor.execute(sql, '667')