ALTER PROCEDURE [dbo].[Search] @pageIndex int, @pageSize int, @key nvarchar(256), @query nvarchar(256), @style tinyint, @sortColumn nvarchar(256), @sortDirection nvarchar(256) AS BEGIN SET NOCOUNT ON declare @sql nvarchar(500) set @sql=N' DECLARE @tempTable TABLE ( TID int identity(1,1), Number nvarchar(30), Price float ) ' IF @style = 1 IF len(@query) = 3 set @sql=@sql+N' INSERT INTO @tempTable ( Number, Price ) SELECT number,price FROM dbo.Plate WHERE secondNumber ='''+ @key +N''' AND LastNumber ='''+ @query + N''' AND style='''+ @style +N''' ORDER BY '+@sortColumn+' '+@sortDirection EXEC(@sql) end
@pageIndex int,
@pageSize int,
@key nvarchar(256),
@query nvarchar(256),
@style tinyint,
@sortColumn nvarchar(256),
@sortDirection nvarchar(256)
AS
BEGIN
SET NOCOUNT ON
declare @sql nvarchar(500)
set @sql=N'
DECLARE @tempTable TABLE
(
TID int identity(1,1),
Number nvarchar(30),
Price float
) ' IF @style = 1
IF len(@query) = 3
set @sql=@sql+N'
INSERT INTO @tempTable
( Number,
Price
)
SELECT number,price
FROM dbo.Plate
WHERE secondNumber ='''+ @key +N''' AND LastNumber ='''+ @query +
N''' AND style='''+ @style +N''' ORDER BY '+@sortColumn+' '+@sortDirection
EXEC(@sql)
end