27,579
社区成员
发帖
与我相关
我的任务
分享求SQL存储过程中使用传入参数作为字段解决方法
Creat PROCEDURE Proc_GetSearchResult
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
select count(UserId)from View_VehicleInfo where @FStr(此为字段名).....
begin
..............
set nocount off
GO
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
select count(UserId)from View_VehicleInfo where @FStr(此为字段名).....
begin
..............
set nocount off
GO
...全文
请发表友善的回复…
发表回复
churchatp1 2005-11-23
- 打赏
- 举报
Creat PROCEDURE Proc_GetSearchResult
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
exec('select count(UserId) from View_VehicleInfo where '+@FStr+'.....')
begin
..............
set nocount off
GO
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
exec('select count(UserId) from View_VehicleInfo where '+@FStr+'.....')
begin
..............
set nocount off
GO
子陌红尘 2005-11-23
- 打赏
- 举报
动态表名/列名的情况都可以用拼装字符串，通过exec执行的方式来处理。
子陌红尘 2005-11-23
- 打赏
- 举报
Creat PROCEDURE Proc_GetSearchResult
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
exec('select count(UserId) from View_VehicleInfo where '+@FStr+'.....')
begin
..............
set nocount off
GO
(@pagesize int,
@pageindex int,
@Skey varchar(200),
@FStr varchar(20)
)
as
set nocount on
exec('select count(UserId) from View_VehicleInfo where '+@FStr+'.....')
begin
..............
set nocount off
GO
