Web Listing 3: Code for Creating Example Objects 
USE tempdb
GO
CREATE TABLE ap1( c CHAR(10) NOT NULL, b varbinary(10) NOT NULL)
CREATE TABLE ap2( c CHAR(10) NOT NULL, b varbinary(10) NOT NULL)
CREATE TABLE ap3( i INT NOT NULL PRIMARY KEY, c VARCHAR(10) NOT NULL)
GO
-- Disable ANSI_PADDING:
SET ANSI_PADDING OFF
GO
CREATE TABLE ap4( c CHAR(10) NOT NULL, b varbinary(10) NOT NULL)
ALTER TABLE ap3 ADD v VARCHAR(10) NULL
GO
SET ANSI_PADDING ON
GO

-- Create procedures and functions.
SET ANSI_NULLS, QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE p1 AS RETURN 
GO
CREATE FUNCTION f1() RETURNS INT AS
BEGIN
    RETURN 1
END
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE p2 AS RETURN 
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION f2() RETURNS INT AS
BEGIN
    RETURN 1
END
GO
CREATE TRIGGER ins_ap1 ON ap1 AFTER INSERT
AS
RETURN
GO
SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS, QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE p3 AS RETURN
GO
CREATE FUNCTION f3() RETURNS INT AS
BEGIN
    RETURN 1
END
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON
GO