alter proc ProductSearch
(
@type nvarchar(50),
@KeyWord nvarchar(255)
)
as EXEC('select *,bookcost*bookRebate as Nowcost from book where '+ @type+' like ''%'+ @KeyWord+'%''')
go
为什么存储过程要用EXEC
什么情况下才用EXEC
说明理由 重分奖赏 顶者1分
...全文
12114打赏收藏
EXEC
alter proc ProductSearch ( @type nvarchar(50), @KeyWord nvarchar(255) ) as EXEC('select *,bookcost*bookRebate as Nowcost from book where '+ @type+' like ''%'+ @KeyWord+'%''') go 为什么存储过程要用EXEC 什么情况下才用EXEC 说明理由 重分奖赏 顶者1分