select * from @t
认真吗有人告诉我它在说谎。
create procedure WorkIt
as
set nocount on
create table #pivot
(
Name varchar(30),
Value decimal,
Grade varchar(2)
)
insert into #pivot
select 'Repeating Pct', 1, 'K'
union all
select 'Repeating Pct', 2, '1'
union all
select 'Repeating Pct', 3, '2'
union all
select 'Repeating Pct', 4, '3'
union all
select 'Repeating Pct', 5, '4'
union all
select 'Repeating Pct', 6, '5'
union all
select 'Repeating Pct', 7, '6'
union all
select 'Repeating Pct', 8, '7'
union all
select 'Repeating Pct', 9, '8'
union all
select 'Repeating Pct', 10, '9'
union all
select 'Repeating Pct', 11, '10'
union all
select 'Repeating Pct', 12, '11'
union all
select 'Repeating Pct', 13, '12'
declare @t table
(
name varchar(30),
K decimal (15,5) ,
[1] decimal (15,5),
[10] decimal (15,5),
[11] decimal (15,5),
[12] decimal (15,5),
[2] decimal (15,5),
[3] decimal (15,5),
[4] decimal (15,5),
[5] decimal (15,5),
[6] decimal (15,5),
[7] decimal (15,5),
[8] decimal (15,5),
[9] decimal (15,5)
)
insert into @t
exec dbo.CrossTabWithoutSumWithOrderBy #pivot, 'Name', null, 'Grade', 'Value',
-- sort repeating pct to bottom
'case name when ''Repeating Pct'' then 999 else 0 end'
drop table #pivot
select * from @t
结果
name K 1 10 11 12 2 3 4 5 6 7 8 9
Repeating Pct 2.00000 11.00000 12.00000 13.00000 3.00000 4.00000 5.00000 6.00000 7.00000 8.00000 9.00000 10.00000 1.00000
最佳答案
当 Entity Framework 尝试从存储过程中检索列时,它将调用SET FMTONLY ON
,然后执行存储过程。当FMTONLY
为ON
时,执行仅返回元数据,并且不适用于存储过程中的某些高级构造-例如动态SQL,临时表以及表变量。
您有三种选择:
SET FMTONLY OFF
。这将使您的存储过程真正执行,因此请确保它仅读取数据-每次尝试检索列时都会执行任何插入,更新或删除操作! 关于c# - Entity Framework 无法处理简单的表变量?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/5997033/