sql - Not taking into account condition -

-

Suppose i have a parameter @ user id, this can be 0 (no user specified) or own id The structure of the query is as follows: 

  If @UserID & gt; Select 0 ... where UserID = @ UserID ... else if select @userid = 0 ... ou ...   
 What do I need to do the following structure   Select  ... where the user id & gt; 0 then userID = @ USIDID and ignore this condition ...   
 thanks   
 
 
 Set as parameter value instead of 0 (zero)  
  Announce @id int set @id = null * From users (id = @ Id) or (@IID is empty)

Comments

Post a Comment

Popular posts from this blog

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

php - proc_open Too many open files in long running Symfony Console app -

-
I have created a console app with a SIM console console component. It was going to run for 5 hours but after running 2 hours I have a proc_open (): Many open files in the pipeline error Symfony \ Component \ Console \ Application.php On-line 985. I tried to gc_collect_cycles in my code, but got the same error. Is this a Symphonic Console component bug or should I not run any app for this long time (but I have to)? This problem relates to: Obviously you have many resources in your app It's not a symphony console bug, but it's a PHP bug. You can modify your program by using another programming language to open fewer files.
Read more

c# - Show a huge number of data in DevExpress GridView -

-
With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load) All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want? Example I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid. Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); } and to call it on the grid listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient; If you need to display large amounts of records in the grid control, ...
Read more