What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.
USE [QuoteDB] GO /****** Object: StoredProcedure [dbo].[sprocSearchPart] Script Date: 05/07/2009 10:16:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sprocSearchPart] ( @pnpartnumber as varchar(100), @pntitle as varchar(100), @pndetail as varchar(100) ) AS if (@pnpartnumber is null) BEGIN set @pnpartnumber = '' END if (@pntitle is null) BEGIN set @pntitle='' END if (@pndetail is null) BEGIN set @pndetail ='' END declare @pnpartnumber_flg int declare @pntitle_flg int declare @pndetail_flg int SET @pnpartnumber_flg = 1 SET @pntitle_flg = 1 SET @pndetail_flg = 1 if (@pnpartnumber ='') BEGIN SET @pnpartnumber_flg = 0 END if (@pntitle ='') BEGIN SET @pntitle_flg = 0 END if (@pndetail ='') BEGIN SET @pndetail_flg = 0 END SELECT pnpartnumber, pntitle, pndetail, pnrevision FROM partnoTbl Where ((@pnpartnumber_flg=1 AND pnpartnumber like '%' + @pnpartnumber+ '%') OR (@pnpartnumber_flg=0))AND ((@pntitle_flg=1 AND pntitle like '%' +@pntitle+ '%')OR (@pntitle_flg=0)) AND ((@pndetail_flg=1 AND pndetail like '%' +@pndetail+ '%')OR (@pndetail_flg=0))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Access 2003, find all instances of database ODBC||3||53|
|Windows Server 2003 STD SP2 as a member server of 2016 domain||11||95|
|How do i delete the last node in an xml in T-SQL||7||29|
|Datatable / Dates ?||4||32|
Join the community of 500,000 technology professionals and ask your questions.