Mega Code Archive
A script that creates a stored procedure that copies a table
<![CDATA[
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
]]>