A script that creates a stored procedure that copies a table : Utility Procedure « Procedure Function « SQL Server / T-SQL Tutorial

14>
15> create table Billings (
16>     BankerID           INTEGER,
17>     BillingNumber      INTEGER,
18>     BillingDate        datetime,
19>     BillingTotal       INTEGER,
20>     TermsID            INTEGER,
21>     BillingDueDate     datetime ,
22>     PaymentTotal       INTEGER,
23>     CreditTotal        INTEGER
24>
25> );
26> GO
1>
2> INSERT INTO Billings VALUES (1, 1, '2005-01-22', 165, 1,'2005-04-22',123,321);
3> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (2, 2, '2001-02-21', 165, 1,'2002-02-22',123,321.);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (3, 3, '2003-05-02', 165, 1,'2005-04-12',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (4, 4, '1999-03-12', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (5, 5, '2000-04-23', 165, 1,'2005-04-17',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (6, 6, '2001-06-14', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (7, 7, '2002-07-15', 165, 1,'2005-04-19',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (8, 8, '2003-08-16', 165, 1,'2005-04-20',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (9, 9, '2004-09-17', 165, 1,'2005-04-21',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (0, 0, '2005-10-18', 165, 1,'2005-04-22',123,321);
2> GO

(1 rows affected)
1>
2> create table BillingCopy (
3>     BankerID           INTEGER,
4>     BillingNumber      INTEGER,
5>     BillingDate        datetime,
6>     BillingTotal       INTEGER,
7>     TermsID            INTEGER,
8>     BillingDueDate     datetime ,
9>     PaymentTotal       INTEGER,
10>     CreditTotal        INTEGER
11>
12> );
13> GO
1>
2> IF OBJECT_ID('spCopyBillings') IS NOT NULL
3>     DROP PROC spCopyBillings
4> GO
1>
2> CREATE PROC spCopyBillings
3> AS
4>     IF OBJECT_ID('BillingCopy') IS NOT NULL
5>         DROP TABLE BillingCopy
6>     SELECT *
7>     INTO BillingCopy
8>     FROM Billings
9>
10> drop table BillingCopy;
11> drop table Billings;
12> GO

21.11.Utility Procedure
	21.11.1.	Create procedure to drop foreign key
	21.11.2.	Spelling single digits.
	21.11.3.	uses system tables to determine the datatype of a field.
	21.11.4.	A stored procedure that tests for a valid foreign key
	21.11.5.	A script that creates a stored procedure that copies a table