RE: CPYF in SQL Server

This

SELECT * INTO TempBackupsop10200.dbo.sop10200 FROM pbs.dbo.sop10200
Go
where sopnumbe = '42759'


Should be

SELECT * INTO TempBackupsop10200.dbo.sop10200 FROM pbs.dbo.sop10200
where sopnumbe = '42759'




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Adam West
Sent: Tuesday, July 07, 2009 2:01 PM
To: Midrange Systems Technical Discussion
Subject: RE: CPYF in SQL Server

this is the error:
(122226 row(s) affected)
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'where'.
Processed 30744 pages for database 'Tempbackupsop10200', file 'TempBackupsop10200' on file 1.
Processed 1 pages for database 'Tempbackupsop10200', file 'TempBackupsop10200_log' on file 1.
BACKUP DATABASE successfully processed 30745 pages in 126.657 seconds (1.988 MB/sec).
and this is the statement
 
CREATE DATABASE TempBackupsop10200
go
SELECT * INTO TempBackupsop10200.dbo.sop10200 FROM pbs.dbo.sop10200
go
where sopnumbe = '42759'
go
Backup Database [Tempbackupsop10200] To Disk = 'C:\MyBackupsop10200.bak'
go
Drop Database Tempbackupsop10200
 
 
-- On Tue, 7/7/09, Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx> wrote:


From: Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx>
Subject: RE: CPYF in SQL Server
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Tuesday, July 7, 2009, 6:33 PM

although it bombs at the end on that statement but it does the copy

non the less.

Things don't go boom for no good reason in SQLServer. What's the error
message?

-Walden