By no means am I SQL efficient!
But this should be easy ( shouldn't it?)
I created this query to update a new database structure from my old one with the query wizard in enterprise manager and modified it accordingly.
We are trying to change to a new ecommerce solution if we can get the data over!
It runs without errors in query manager but nothing gets transferred.
both databases are on the same server and security has been disabled for now.
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:45:38 PM ******/
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:26:39 PM ******/
ALTER PROCEDURE insert_sfManufacturers_1
(@mfgID_1 [int],
@mfgName_2 [nvarchar](30),
@mfgLogo_3 [nvarchar](50))
AS INSERT INTO [storefront5SQL].[dbo].[sfManufacturers]
( [mfgID],
[mfgName],
[mfgLogo])
SELECT [mfgID], [mfgName], [mfgLogo]
FROM [dontneednew].[dbo].[EXPORTManufacturers]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
if I try to create the same thing in query analyser i get
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:45:38 PM ******/
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:26:39 PM ******/
ALTER PROCEDURE insert_sfManufacturers_1
(@mfgID_1 [nvarchar](50),
@mfgName_2 [nvarchar](30),
@mfgLogo_3 [nvarchar](50))
AS INSERT INTO [storefront5SQL].[dbo].[sfManufacturers]
( [mfgID],[mfgName],[mfgLogo])
SELECT ( [mfgID],[mfgName],[mfgLogo])
FROM [dontneednew].[dbo].[EXPORTManufacturers]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Server: Msg 170, Level 15, State 1, Procedure insert_sfManufacturers_1, Line 14
Line 14: Incorrect syntax near ','.
So after 2 days, I give up
Please help
Paul D
dontneednew.com
But this should be easy ( shouldn't it?)
I created this query to update a new database structure from my old one with the query wizard in enterprise manager and modified it accordingly.
We are trying to change to a new ecommerce solution if we can get the data over!
It runs without errors in query manager but nothing gets transferred.
both databases are on the same server and security has been disabled for now.
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:45:38 PM ******/
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:26:39 PM ******/
ALTER PROCEDURE insert_sfManufacturers_1
(@mfgID_1 [int],
@mfgName_2 [nvarchar](30),
@mfgLogo_3 [nvarchar](50))
AS INSERT INTO [storefront5SQL].[dbo].[sfManufacturers]
( [mfgID],
[mfgName],
[mfgLogo])
SELECT [mfgID], [mfgName], [mfgLogo]
FROM [dontneednew].[dbo].[EXPORTManufacturers]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
if I try to create the same thing in query analyser i get
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:45:38 PM ******/
/****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 2:26:39 PM ******/
ALTER PROCEDURE insert_sfManufacturers_1
(@mfgID_1 [nvarchar](50),
@mfgName_2 [nvarchar](30),
@mfgLogo_3 [nvarchar](50))
AS INSERT INTO [storefront5SQL].[dbo].[sfManufacturers]
( [mfgID],[mfgName],[mfgLogo])
SELECT ( [mfgID],[mfgName],[mfgLogo])
FROM [dontneednew].[dbo].[EXPORTManufacturers]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Server: Msg 170, Level 15, State 1, Procedure insert_sfManufacturers_1, Line 14
Line 14: Incorrect syntax near ','.
So after 2 days, I give up
Please help
Paul D
dontneednew.com