How to write searched stored procedures?

baijiang

I don't know whether to use dynamic queries with query conditions as parameters or define a parameter for each query condition?

sinexe

Dynamic query uses query conditions as parameters

恶魔右指

The landlord is best to look at the online help instructions, and then look at the examples you wrote, which is easier to get started.
Store data and queries that can be used to change tables

fanfan1980

Recommended parameters

baijiang

Are there any good examples of LS friends?
I am also suffering from no examples and no experience

ninmaru

CREATE PROCEDURE SplitPage
@SQL VARCHAR(400),
@Page int,
@RecsPerPage int,
@ID VARCHAR(255),
@Sort VARCHAR(255),
@where VARCHAR (255)

AS

DECLARE @Str nVARCHAR(4000)

SET @Str='SELECT TOP'+CAST(@RecsPerPage AS VARCHAR(20))+' * FROM'+@SQL+' WHERE'+@where +'and'+@ID+' NOT IN (SELECT TOP'+CAST( (@RecsPerPage*(@Page-1)) AS VARCHAR(20))+''+@ID+' FROM'+@SQL+' where'+@where+' ORDER BY'+@Sort+') ORDER BY'+@Sort
PRINT @Str EXEC sp_ExecuteSql @Str
GO

pguppgdn

Use query conditions as parameters
create proc showpage
@pagesize int,
@tablename nvarchar(250),
@pagecount int
@strwhere nvachar(4000)
as
begin
'''''where @strwhere
end