go create proc test as declare @str varchar(10) sel @str=convert(varchar(10),getdate(),120) exec(' if object('+''''@str''''+') is not null drop table '+@str+' create table '+@str+'( id int, name vaechar(10)) ') exec('insert '+@str+'+' select * from 另外一个表')
CREATE PROCEDURE [dbo].P_Test AS BEGIN create table tb(id int,name nvarchar(10)) insert into tb select 1,'张三' union all select 2,'李四'
select * from tb END exec [dbo].P_Test
CREATE PROCEDURE [dbo].P_Test AS BEGIN create table tb(id int,name nvarchar(10)) insert into tb select 1,'张三' union all select 2,'李四'
select * from tb END exec [dbo].P_Test++++
create PROCEDURE [dbo].P_Test AS BEGIN declare @a varchar(150) declare @b varchar(150) declare @c varchar(150) declare @table varchar(50) set @table=CONVERT(varchar(10),GETDATE(),120) set @a=' create table '+quotename(@table)+' (id int,name nvarchar(10)) ' exec(@a) set @b= 'insert into '+quotename(@table)+' select 1,'+'''张三'+''' union all select 2,'+'''张三''' exec(@b)
set @c=' select * from '+quotename(@table) exec(@c) END刚才错了这个是对的
create proc test
as
declare @str varchar(10)
sel @str=convert(varchar(10),getdate(),120)
exec('
if object('+''''@str''''+') is not null
drop table '+@str+'
create table '+@str+'(
id int,
name vaechar(10))
')
exec('insert '+@str+'+' select * from 另外一个表')
AS
BEGIN
create table tb(id int,name nvarchar(10))
insert into tb
select 1,'张三' union all
select 2,'李四'
select * from tb
END exec [dbo].P_Test
CREATE PROCEDURE [dbo].P_Test
AS
BEGIN
create table tb(id int,name nvarchar(10))
insert into tb
select 1,'张三' union all
select 2,'李四'
select * from tb
END exec [dbo].P_Test++++
create PROCEDURE [dbo].P_Test
AS
BEGIN
declare @a varchar(150)
declare @b varchar(150)
declare @c varchar(150)
declare @table varchar(50)
set @table=CONVERT(varchar(10),GETDATE(),120)
set @a=' create table '+quotename(@table)+' (id int,name nvarchar(10)) '
exec(@a)
set @b= 'insert into '+quotename(@table)+'
select 1,'+'''张三'+''' union all
select 2,'+'''张三'''
exec(@b)
set @c=' select * from '+quotename(@table)
exec(@c)
END刚才错了这个是对的