tag:blogger.com,1999:blog-7805972021499203804.post647065316813196128..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server Return All Records When a Query Parameter is Blank or Null or EmptySuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7805972021499203804.post-77176413700366108362015-03-26T07:49:00.092-07:002015-03-26T07:49:00.092-07:00@sujoy santra code much better...@sujoy santra code much better...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-76130640327999625322015-03-25T03:49:21.364-07:002015-03-25T03:49:21.364-07:00declare @strsearch varchar(50)=null
select * from ...declare @strsearch varchar(50)=null<br />select * from @temp where location= isnull(@strsearch,location)sujoy santrahttps://www.blogger.com/profile/13326530161158977787noreply@blogger.com