Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
spGetCars set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER proc [dbo].[spGetCars] ( @uid varchar(30) ) as set nocount on DECLARE @ufilter varchar(200) DECLARE @uexpdate datetime DECLARE @cmd varchar(200) select @ufilter=ufilter, @uexpdate=uexpdate from UFILTERS where uid=@uid IF ISNULL(@ufilter, 'ZZTOP') = 'ZZTOP' BEGIN select * from Cars where 1 = 2 END IF @ufilter = 'NONE' BEGIN select * from Cars order by Make, Model END ELSE BEGIN set @cmd = 'select * from Cars where ' + @ufilter exec (@cmd) END
|total hours between two times grouped by type||6||29|
|Database connection opened on a machine||8||35|
|Help with stripping out character in SQL LEFT/RIGHT/REPLACE||2||16|
|Slow SQL query||12||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!