22,210
社区成员
发帖
与我相关
我的任务
分享
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable EverydayTable READONLY
)
as
insert into EverydayTable
select * from @EverydayTable edt where edt.[date] not in (select [date] from verydayTable)
go
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable nvarchar(50)
)
as
begin
exec('insert into EverydayTable select * from ' + @EverydayTable + 'as edt where edt.[date] not in (select [date] from EverydayTable)')
end
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable nvarchar(50)
)
as
begin
exec('insert into EverydayTable select * from ' + @EverydayTable + 'as edt where edt.[date] not in (select [date] from EverydayTable)'
end
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable table
)
as
exec('insert into EverydayTable
select * from '+ @EverydayTable +' edt where edt.[date] not in (select [date] from EverydayTable) ')
go
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable varchar(20)
)
as
exec('insert into EverydayTable
select * from '+@EverydayTable +' edt where edt.[date] not in (select [date] from EverydayTable) ')
go
这样? create Proc [dbo].[InsertEverydayResult]
@EverydayTable varchar(32)
as
insert into EverydayTable
select * from @EverydayTable edt where edt.[date] not in (select [date] from EverydayTable)
go
create Proc [dbo].[InsertEverydayResult]
(
@EverydayTable table
)
as
exec ('insert into EverydayTable
select * from '+@EverydayTable+' edt where edt.[date] not in (select [date] from EverydayTable)')
go