ALTER PROCEDURE [dbo].[USP_UBSLog_GetAllBySort]
(
@field varchar(50), --表字段名
@direction varchar(50), --排序方向
@logType varchar(50) --类型
)
AS declare @strSQL varchar(6000) -- 主语句if @logType != ''
begin
set @strSQL = ' select * from UBSLog where LogType = ' + @field +
' order by [' + @field +'] ' + @direction -- 这句有问题 不知道哪出错了end
else //@logType 为空时可以查出信息
begin
set @strSQL = ' select * from UBSLog ' +
' order by [' + @field +'] ' + @direction
endexec (@strSQL)
GO
(
@field varchar(50), --表字段名
@direction varchar(50), --排序方向
@logType varchar(50) --类型
)
AS declare @strSQL varchar(6000) -- 主语句if @logType != ''
begin
set @strSQL = ' select * from UBSLog where LogType = ' + @field +
' order by [' + @field +'] ' + @direction -- 这句有问题 不知道哪出错了end
else //@logType 为空时可以查出信息
begin
set @strSQL = ' select * from UBSLog ' +
' order by [' + @field +'] ' + @direction
endexec (@strSQL)
GO
(
@field varchar(50), --表字段名
@direction varchar(50), --排序方向
@logType varchar(50) --类型
)
AS declare @strSQL varchar(6000) -- 主语句if @logType != ''
begin
set @strSQL = ' select * from UBSLog where LogType = ''' + @field +
''' order by [' + @field +'] ' + @direction -- 这句有问题 不知道哪出错了end
else --@logType 为空时可以查出信息
begin
set @strSQL = ' select * from UBSLog ' +
' order by [' + @field +'] ' + @direction
endexec (@strSQL)GO
' order by [' + @field +'] ' + @direction --
改成
set @strSQL = ' select * from UBSLog where LogType = ' + @logType + 赋错值了
' order by [' + @field +'] ' + @direction
谢谢:(
' order by [' + @field +'] ' + @direction --
改成
set @strSQL = ' select * from UBSLog where LogType = ' + @logType + 赋错值了
' order by [' + @field +'] ' + @direction ======请看我上面语句