--------------------------------------------------
-- GetTaskInfoByMultiCondition 按多个信息返回任务信息(是否打印,任务单编号,项目名称)
--------------------------------------------------
CREATE PROCEDURE GetTaskInfoByMultiCondition
@condition_1 nvarchar(50), --taskid
@condition_2 nvarchar(50), --ifprinted
@condition_3 nvarchar(50), --project_item_id
@condition_4 nvarchar(50) --exam_date
AS
SET NOCOUNT ON
declare @sql nvarchar(400)
set @sql='SELECT task_id,project_name,consign_firm,exam_date,printed_date,ifprinted FROM grosstask WHERE ifexam=1 '
set @condition_1=isnull(@condition_1,'')
set @condition_2=isnull(@condition_2,'')
set @condition_3=isnull(@condition_3,'')
set @condition_4=isnull(@condition_4,'') exec(@sql+@condition_1+@condition_2+@condition_3+@condition_4) RETURN 0--------------------------------------------------
--返回一个记录集
------------------------------------------------
GO
-- GetTaskInfoByMultiCondition 按多个信息返回任务信息(是否打印,任务单编号,项目名称)
--------------------------------------------------
CREATE PROCEDURE GetTaskInfoByMultiCondition
@condition_1 nvarchar(50), --taskid
@condition_2 nvarchar(50), --ifprinted
@condition_3 nvarchar(50), --project_item_id
@condition_4 nvarchar(50) --exam_date
AS
SET NOCOUNT ON
declare @sql nvarchar(400)
set @sql='SELECT task_id,project_name,consign_firm,exam_date,printed_date,ifprinted FROM grosstask WHERE ifexam=1 '
set @condition_1=isnull(@condition_1,'')
set @condition_2=isnull(@condition_2,'')
set @condition_3=isnull(@condition_3,'')
set @condition_4=isnull(@condition_4,'') exec(@sql+@condition_1+@condition_2+@condition_3+@condition_4) RETURN 0--------------------------------------------------
--返回一个记录集
------------------------------------------------
GO
解决方案 »
- 多表查询行列统计
- SQL语句出错。
- 如何按指定格式(如使用千分符)导出为EXCEL
- 这个用存储过程怎么实现
- 怎样可以修改表结构而不丢失原有数据
- 如何發生死鎖?
- Unable to read local eventlog (reason: 事件日志文件已在读取间更改。).
- 比较难的问题,关于索引问题,高手请进!!!!
- 第六次提出这个问题:如何通过DELPHI调用SQL SERVER 过程向SQL SERVER 存入图象
- 100分求助,请问一sqlserver链接远程服务器的问题!
- 无法启动分布式服务是怎么回事,谢谢各位老大
- select @fieldname from tablename 如何能达到这个目的?
select @sql+isnull(@condition_1,'')+' '+isnull(@condition_2,'')+' '+isnull(@condition_3,'')+' '+isnull(@condition_4,'')
然后拷贝执行一下看看。
@condition_1 nvarchar(50), --taskid
@condition_2 nvarchar(50), --ifprinted
@condition_3 nvarchar(50), --project_item_id
@condition_4 nvarchar(50) --exam_date
AS
SET NOCOUNT ON
declare @sql nvarchar(400)
set @sql='SELECT task_id,project_name,consign_firm,exam_date,printed_date,ifprinted FROM grosstask WHERE ifexam=1 '
select @sql = @sql + isnull(@condition_1,'') + ' ' + isnull(@condition_2,'') + ' ' + isnull(@condition_3,'') + ' ' + isnull(@condition_4,'')
exec(@sql)