Question Insert one database table record to another database table in sql server 2000

[prasad kulkarni]

HI,

how to insert one database table record to another database table
in sql server 2000

if any know , then reply me soon

 

[cjard]

If destination not exists:
SELECT fields INTO destination FROM source

If exists:
INSERT INTO destination SELECT fields FROM source