Listing 1

CREATE PROCEDURE pr_getStates
AS
SELECT
StateName
FROM
States
ORDER BY
StateName

Listing 2

<CFQUERY NAME="getStates"
DATASOURCE="#REQUEST.DS#"
CACHEDWITHIN="#CreateTimeSpan(0,0,60,0)#">
EXEC pr_getStates
</CFQUERY>

Listing 3

<CFQUERY NAME="insertUser"
DATASOURCE="#REQUEST.DS#">
INSERT INTO
Users
(FirstName,
LastName,
User_TS)
VALUES
Ô#Variables.FirstName#Õ,
Ô#Variables.LastName#Õ,
getDate()
</CFQUERY>

Listing 4

CREATE TRIGGER tr_updateItemTS ON Items
FOR UPDATE
AS

DECLARE
@Item_Pk int

IF Update(ItemMin)
BEGIN
SELECT
@Item_Pk = Item_Pk
FROM
Deleted

UPDATE
Items
SET
ItemEditDate = getDate()
WHERE
Item_Pk

Listing 5

CREATE TRIGGER tr_PreventGCDelete ON GiftCertificate
FOR DELETE
AS

DECLARE @GC_Pk [int]

BEGIN
SELECT
@GC_Pk = GC_Pk
FROM
Deleted

IF @GC_Pk = 1
BEGIN
ROLLBACK TRANSACTION
END
END

Listing 6

<CFQUERY NAME="getName"
DATASOURCE="#REQUEST.DS#">
SELECT
FirstName,
LastName
FROM
Name1
</CFQUERY>

<CFLOOP QUERY="getName">
<CFQUERY NAME="InsertName"
DATASOURCE="#REQUEST.DS#">
INSERT INTO
Name2
(FirstName,
LastName)
VALUES
(Ô#getName.FirstName#Õ,
Ô#getName.LastName#Õ)
</CFQUERY>
</CFLOOP>

Listing 7

<CFQUERY NAME="copyNames"
DATASOURCE="#REQUEST.DS#">
INSERT INTO
Names2
(FirstName,
LastName)
SELECT
FirstName,
LastName
FROM
Names1
</CFQUERY>