大富翁论坛竟然没有人会写这个SQL语句！！！！ (50分)

数据库：dbBackup
数据库：dbSource
表：tDetail (数据库：dbBackup)
表：tDetail (数据库：dbSource)
注意：两个表结构相同！
--------------------------------------------------
USE dbBackup
INSERT tDetail
(
USE dbSource
SELECT * FROM tDetail ORDER BY ciId ASC
)
-------------------------------------------------
要把dbSource里表tDetail的所有数据Insert到dbBackup的
tDetail中，怎么写？

用BATCHMOVE控件吧，很简单的啦！！！

你用的什么数据库，是ORACLE就简单啦，copy语句可以搞定。

我用的数据库：MS SQL SERVER 2000

用DELPHI的BATCHMOVE组件；
设定它的源和目标之后；batchmove1.execute一就可以了;
源(tbl_source)和目标(tbl_des)可以是两个TABLE组件;
tbl_source可以指向SQL SERVER数据库中的表；

INSERT INTO dbBackup.dbo.tDetail
SELECT * FROM dbSource.dbo.tDetail

INSERT INTO dbBackup (SELECT * FROM dbSource)

告诉你用DTS就在export data中通过ole连接就可以！
不要用sql,简单方便！而且表不一样也可以！

INSERT INTO dbBackup.dbo.tDetail
SELECT * FROM dbSource.dbo.tDetail

dbBackup：数据库名
dbo：数据库所有者名
tDetail：表名

我是这么写的，提示错误：
DECLARE @sdtStartDate SMALLDATETIME
DECLARE @sdtEndDate SMALLDATETIME

SET @sdtStartDate = '2001-11-01'
SET @sdtEndDate = '2001-11-30'

INSERT INTO HJBackup.dbo.tUserMasterInfo
SELECT * FROM HJMIS.dbo.tUserMasterInfo AS M
WHERE (DATEDIFF(dy,@sdtStartDate,M.cmdUMIDate)>=0)
AND (DATEDIFF(dy,@sdtEndDate,M.cmdUMIDate)<=0)
-------------------------------------------------------
Insert Error: Column name or number of supplied values does not match
table definition.
-------------------------------------------------------
可是我的表结构是相同的啊！天啦，这是怎么回事？

--我这个存储过程有什么问题！！！！！！！！！
--sp_BackupData '2001-11-01','2001-11-30'

if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[sp_BackupData]')
and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_BackupData]
GO
CREATE PROC sp_BackupData
(
@sdtStartDate SMALLDATETIME,
@sdtEndDate SMALLDATETIME
)
AS
BEGIN
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tUserMasterInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [tUserMasterInfo] (
[ciUMIId] [int] NOT NULL ,--IDENTITY (1, 1) NOT NULL ,
[cvcUMITableNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ciUMIPersonNum] [int] NULL ,
[cvcUMIBillNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cmdUMIDate] [smalldatetime] NULL ,
[ciUMIMode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cvcUMIWaiter] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cvcUMIReceiver] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ciUMIPaymentType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cnUMITotal] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cnUMITotal] DEFAULT (0),
[cnUMIServiceFare] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cnUMIServiceFare] DEFAULT (0),
[cvcUMIRemark] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[cvcUMISignature] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ciUMIFlags] [int] NULL CONSTRAINT [DF_tUserMasterInfo_ciUMIFlags] DEFAULT (1),
[ciUMIBillType] [float] NULL ,
[ciUMIDiscountType] [int] NULL CONSTRAINT [DF_tUserMasterInfo_ciUMIDiscountType] DEFAULT (0),
[cbUMIInvoice] [bit] NULL CONSTRAINT [DF_tUserMasterInfo_ctiUMIInvoice] DEFAULT (0),
[cbUMIFreeBill] [bit] NULL CONSTRAINT [DF_tUserMasterInfo_ctiUMIFreeBill] DEFAULT (0),
[cbUMIAuditFlag] [bit] NULL CONSTRAINT [DF_tUserMasterInfo_cbUMIAuditFlag] DEFAULT (0),
[cmUMIPrefer] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmUMIPrefer] DEFAULT (0),
[cbFeastFlag] [bit] NULL CONSTRAINT [DF_tUserMasterInfo_cbFeastFlag] DEFAULT (0),
[ciPrintNum] [int] NULL CONSTRAINT [DF_tUserMasterInfo_ciPrintNum] DEFAULT (1),
[cbPosition] [bit] NULL CONSTRAINT [DF_tUserMasterInfo_cbPosition] DEFAULT (0),
[cvcPrintPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[cmDiscount] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmDiscountTotal] DEFAULT (0),
[cmTotalHK] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmTotalHK] DEFAULT (0),
[cmDiscountHK] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmDiscountHK] DEFAULT (0),
[cmServiceFareHK] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmServiceFareHK] DEFAULT (0),
[cmPreferHK] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmPreferHK] DEFAULT (0),
[cmOriginTotal] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmOriginTotal] DEFAULT (0),
[cmOddment] [money] NULL CONSTRAINT [DF_tUserMasterInfo_cmOddment] DEFAULT (0),
CONSTRAINT [PK_tUserInfoMaster] PRIMARY KEY CLUSTERED
(
[ciUMIId]
) ON [PRIMARY]
) ON [PRIMARY]
CREATE UNIQUE INDEX [UMIBillNo] ON [dbo].[tUserMasterInfo]([cvcUMIBillNo] DESC ) ON [PRIMARY]
CREATE INDEX [cmdUMIDate] ON [dbo].[tUserMasterInfo]([cmdUMIDate] DESC ) ON [PRIMARY]
END

INSERT INTO HJBackup.dbo.tUserMasterInfo SELECT * FROM HJMIS.dbo.tUserMasterInfo AS M WHERE (DATEDIFF(dy,@sdtStartDate,M.cmdUMIDate)>=0) AND (DATEDIFF(dy,@sdtEndDate,M.cmdUMIDate)<=0)

if NOT exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tUserDetailInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [tUserDetailInfo] (
[ciUDIId] [int] NOT NULL ,--IDENTITY (1, 1) NOT NULL ,
[ciUDIUMIId] [int] NULL ,
[ciUDIValue] [int] NULL ,
[cvcUDIDetails] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cvcUDIUnit] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[cnUDIUnitPrice] [money] NULL ,
[cnUDIQuantity] [float] NULL CONSTRAINT [DF_tUserDetailInfo_cnUDIQuantity] DEFAULT (1),
[cnUDIAmount] [money] NULL ,
[cnUDIAgio] [float] NULL ,
[ciUDIFId] [int] NULL ,
[ccUDIType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[cvcFoodNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ciDepartId] [int] NULL ,
CONSTRAINT [PK_tUserDetailInfo] PRIMARY KEY CLUSTERED
(
[ciUDIId]
) ON [PRIMARY]
) ON [PRIMARY]
CREATE INDEX [UDIUMIId] ON [dbo].[tUserDetailInfo]([ciUDIUMIId] DESC ) ON [PRIMARY]
END
INSERT INTO HJBackup.dbo.tUserDetailInfo SELECT D.* FROM HJMIS.dbo.tUserMasterInfo AS M, HJMIS.dbo.tUserDetailInfo AS D WHERE M.ciUMIId = D.ciUDIUMIId AND DATEDIFF(dy,@sdtStartDate,M.cmdUMIDate)>=0 AND DATEDIFF(dy,@sdtEndDate,M.cmdUMIDate)<=0
END

GO

INSERT INTO dbBackup.dbo.tDetail
SELECT * FROM dbSource.dbo.tDetail

INSERT INTO HJBackup.dbo.tUserMasterInfo
SELECT * FROM HJMIS.dbo.tUserMasterInfo AS M

把*换成具体的字段名,再不行,把insert表中的字段也列上