Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.