34,591
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE dfe
@var SYSNAME
AS
IF OBJECT_ID('t')>0
DROP TABLE t
EXEC (
'SELECT colum INTO t
FROM table1;
SELECT colum
FROM t'
)
GO
CREATE PROCEDURE pro
@var SYSNAME
AS
SELECT * INTO #mb FROM mb WHERE 1 = 0
IF @var='a'
INSERT INTO #mb SELECT * FROM mb
ELSE
IF @var='b'
INSERT INTO #mb SELECT * FROM mb
GO
可以先搭好框架,再判断条件插入数据。CREATE PROCEDURE dfe
@var sysname
AS
drop table t
select colum into t from table1
exec('select colum from t')
GO
CREATE PROCEDURE dfe
@var sysname
AS
drop table t
select colum into t from table1
select colum from t
GO