Amr.Mohammad87

SELECT Column1, Column2, Column3... From [table name goes here] WHERE [condition goes here for filtering result "if wished"] Try not to use `SELECT * FROM [table name]` as it is not a performance wise. Try to specifiy the columns as possible as you can. The execution steps followed by the …

Greetings, I am reading about Entity Framework and I stopped by a sentence that I do not understand it *You can simply iterate over the contents of any given DbSet and Entity Framework will send a query to the database to find all the data in that set. The query …

Greetings, I am a newbie in web development and I am working on a website backend using ***ASP.NET***, ***Bootstrap***, and ***jQuery*** and I need to upload files, simply photos, that will be used to be displayed on the frontend banners. I already used the HTML5 file API to read the …

Greetings, The reason can vary. 1. Your database login credentials (i.e. the authentication information) are wrong or have been changed. 2. Your database server is unresponsive. 3. Your database has been corrupted. Make sure that you are getting the same error on both the front end of the site, and …

Greetings, I am developing a backend website using ASP.NET. I had a 3 GridView controls within the page. I am using the jQuery to add a CSS class to third column of the 3 GridViews when the page in ready as I tried to add this class by setting the …

Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried …

I've read the following statement and I cannot understand something within it "*In all binary trees, there are at most 2^i nodes at level i + 1*" what I cannot understand is that tree's levels start at level 0, however, if we apply what is written in this statement there …

Greetings, I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are: 1- BCNF - Boyce-Codd Normal Form 2- 4NF 3- 5NF 4- ONF - …

void assign(size_type n, **el const T& el = T()**) This function is a member function of the STL list class and I do not understand the bolded part. I understand the const T& el is a reference to a constant parameter which means I cannot change the value/content of the …

Greetings, I am a windows OS user, however, I installed a VMware and I need to install Linux OS on a virtual machine. I searched for Linux official website to download the lastest version of the OS from it and unfortunately I did not find, or I could not be …

Greetings, First of all do you know what is meant by **Polymorphism**?. Simply, it means to treat objects of the derived class as if they were objects of the base class. `baseType btVar = new derivedType()` In addition, when you use a variable of base class type to hold a …

Unfortunately we will not be able to help you that way :(. However, try to comment that line and try again if everything goes 100% well, in that case, there is a problem in the ribbon control?. Use a try/catch block in this segment of code and show us the …

SELECT s_id.uc_student,COUNT(max_enrl.uc_course_section) AS NumberOfOrders FROM uc_course_section,uc_student,uc_enrollment LEFT JOIN uc_student ON uc_enrollment.uc_student=uc_enrollment.**NOTICE** GROUP BY s_id,s_last; Can you notice the word *NOTICE* I wrote within the code. You put the "." operator and you do not put the column name after that is why you are getting incorrect sytanx error. I hope …

Use the moduls operator and you will get the result of 2, the result you want. If you want to split something in SQL Server try to use substring method and notice that this method used with strings only.

You have to find a balance between normalization and de-normalization. De-normalization is commonly used for reporting and OLAP workloads. So for tables that will have workloads use de-normalization when designing them for other tables that will not workloads use the normalization. Of course, all of this depending on your bussiness. …