Listing 1
<CFQUERY NAME="gettotal">
SELECT
Total,
LastName
FROM
Purchase
WHERE
Customer = 'Bill'
</CFQUERY>
<CFLOOP QUERY="total">
<CFQUERY NAME="enterTotal">
INSERT INTO
History
(total,name)
VALUES
(#gettotal.Total#,'#gettotal.LastName#')
</CFQUERY>
</CFLOOP>

Listing 2
CREATE PROCEDURE sp_getBooks AS
SELECT
Titles
FROM
Books
ORDER BY
Titles

Listing 3
CREATE PROCEDURE sp_getBooks
@Author [varchar](30),
@Price [money]
AS
SELECT
Titles
FROM
Books
WHERE
Author = @Author
AND
Price < @Price
ORDER BY
Titles

Listing 4
<CFSTOREDPROC PROCEDURE="sp_getBooks"
DataSource="Books">
<CFPROCPARAM TYPE="In" CFSQLTYPE="varchar"
DBVARNAME="@Author"
VALUE="#Attributes.Author#">
<CFPROCPARAM TYPE="In" CFSQLTYPE="money"
DBVARNAME="@Price"
VALUE="#Attributes.Price#">
<CFPROCRESULT NAME="getTitles" RESULTSET="1">
</CFSTOREDPROC>

Listing 5
CREATE PROCEDURE sp_createOrder
@Address [varchar](30),
@Item [int],
@Quantity [int]
AS

DECLARE
@NewIdent [int]

INSERT INTO
Orders
(Address)
VALUES
(@Address)

SET @NewIdent = @@Identity

INSERT INTO
OrderDetail
(Orders_Fk,
Item,
Quantity)
VALUES
(@NewIdent,
@Item,
@Quantity)

Listing 6
CREATE PROCEDURE sp_updateInventory
@MinInventory [int],
@RowsAffected [int]OUTPUT
AS

UPDATE
Items
SET
LowStock = 'Y'
WHERE
Quantity < @MinInventory

SET @RowsAffected = @@Rowcountt

Listing 7
<CFSTOREDPROC PROCEDURE="sp_updateInventory"
DataSource="Books">
<CFPROCPARAM TYPE="In" CFSQLTYPE="integer"
DBVARNAME="@MinInventory"
VALUE="#Attributes.Min#">
<CFPROCPARAM TYPE="Out" CFSQLTYPE="integer"
DBVARNAME="@RowsAffected"
VARIABLE="Variables.LowInvCount">
</CFSTOREDPROC>

Listing 8
CREATE PROCEDURE sp_updatePrice
@NewPrice [money],
@Item [int],
@Error [int]OUTPUT
AS

UPDATE
Items
SET
Price = @NewPrice
WHERE
ItemNumber = @Item

IF @@Error <> 0
BEGIN
SET @Error = @@Error
(error handling code)
END
ELSE
BEGIN
SET @Error = 0
END