simple stored procedure

[dave]

Hi there!!
I want to try stored proceudre that copies one field data
from table1 to table2..

Can any one suggest how to write? I searched on net but
no success yet...

Thanx
dave

[Jeff Cochran]

On Mon, 5 Apr 2004 22:46:43 -0700, "dave"
<anonymous@discussions.microsoft.com> wrote:

>I want to try stored proceudre that copies one field data
>from table1 to table2..
>
>Can any one suggest how to write? I searched on net but
>no success yet...

Books online has all this, assuming you used MS SQL Server.

Jeff

[Bob Barrows [MVP]]

dave wrote:

> Hi there!!
> I want to try stored proceudre that copies one field data
> from table1 to table2..

Is this what you want?

CREATE TABLE table1 (col1 int)
go
INSERT INTO table1 VALUES(2)
INSERT INTO table1 VALUES(3)
go
CREATE TABLE table2 (col1 int)
go
CREATE PROCEDURE CopyRows AS
INSERT INTO table2 (col1)
SELECT col1 FROM table1
go
exec CopyRows
Select col1 from table2
go
drop procedure CopyRows
drop table table1
drop table table2


If not, perhaps you should provide some more details ...

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.