--公共查询一张表的存储过程
create proc commmonGetData
(
@tableName varchar(50),
@condation varchar(150),
@myCount int output
)
as
begin
create proc commmonGetData
(
@tableName varchar(50),
@condation varchar(150),
@myCount int output
)
as
begin
declare @strs nvarchar(500)
set @strs=''
set @strs=''
if(@condation='')
begin
set @strs = 'select * from'+ @tableName
end
begin
set @strs = 'select * from'+ @tableName
end
if(@condation!='')
begin
set @strs = 'select * from '+ @tableName+' where '+@condation
set @strs = 'select * from '+ @tableName+' where '+@condation
end
exec sp_executesql @strs
end
- - exec commmonGetData 'T_User',' Fusername=''admin''',0
CREATE PROCEDURE [dbo].[spSearchStudentInfo]
@StartDate DATETIME = NULL,
@EndDate DATETIME = NULL
AS
BEGIN
SELECT ID,Name,StartDate,EndDate,Age
FROM dbo.Student WITH(NOLOCK)
WHERE (StartDate >= @StartDate OR @StartDate IS NULL) AND (EndDate <= @EndDate OR @EndDate IS NULL)
END