Create table #1(ID int,Name sysname,I INT,Q INT) insert into #1 exec S 1 DROP TABLE #1 CREATE PROCEDURE S @I INT AS BEGIN SELECT 1,2 FROM Fact_MamaClub_Member_Statistics END 我这样写提示列名或所提供值的数目与表定义不匹配
Create table #1(ID int,Name sysname,I INT,Q INT) insert into #1 exec S 1 DROP TABLE #1 CREATE PROCEDURE S @I INT AS BEGIN SELECT 1,2 FROM Fact_MamaClub_Member_Statistics END 我这样写提示列名或所提供值的数目与表定义不匹配 Create table #1(ID int,Name sysname,I INT,Q INT) 列名(可不同)和类型要相同 SELECT 1,2 FROM Fact_MamaClub_Member_Statistics
Create table #1(ID int,Name sysname)--同 存储过程1结果集相同栏位和类型
insert into #1 exec 存储过程1 参数1SQL2008以上版本用表类开直接获取
insert into #1 exec S 1
DROP TABLE #1
CREATE PROCEDURE S
@I INT
AS
BEGIN
SELECT 1,2 FROM Fact_MamaClub_Member_Statistics
END
我这样写提示列名或所提供值的数目与表定义不匹配
insert into #1 exec S 1
DROP TABLE #1
CREATE PROCEDURE S
@I INT
AS
BEGIN
SELECT 1,2 FROM Fact_MamaClub_Member_Statistics
END
我这样写提示列名或所提供值的数目与表定义不匹配
Create table #1(ID int,Name sysname,I INT,Q INT)
列名(可不同)和类型要相同
SELECT 1,2 FROM Fact_MamaClub_Member_Statistics