Let's say that a site using WordPress has half the posts of the standard type, and the other half uses a Custom Post Type "review" .
But this type of post had no registered tags, so it shared those of the standard posts (post_tag).
After...
The installation parameters are as follows, but when attempting to make an error and the installation is aborted.
C:\Setup.exe /QS /ACTION="Install" /FEATURES="SQL" /INSTANCENAME="SQLEXPRESS" /SECURITYMODE=SQL /SAPWD=senha
I'm developing a follower system, I created a page that searches for registered users. You type in an input a name, and it checks to see if you have any records with that name in the database.
I put a Follow button next to each name that re...
I need to calculate the final grade point average for students in a class, I tried using the avg function of SQL, but I did not succeed, the code is this:
<?php
$idTurma = $_GET["idTurma"];
$idDisciplina = $_GET["idDisciplina...
To be honest, I do not even know how to start my question. So I'll first put the information I have.
I have the following structure in my database.
I need to do a SELECT that returns me the following:
How can I achieve this?
...
I have a table with a column named X in it I enter comma-separated values, for example: 1,2,3,4,5 .
I use this query to get a particular row.
SELECT * FROM 'x' WHERE CONCAT(',',x,',') LIKE '%,1,2,%'
I wanted to adapt...
I have a table with 4 different columns, 2 of them indicating the beginning (date and time) and another 2 indicating end (also date and time). Is there a way to sort the result so that it prioritizes the most recent event? for example: If the en...
I'm running a query in the database to return 6 results from a Agenda table that has multiple available times per day (eg: 08: 10: 00: 000 | 08: 30: 00: 000 ) and for periods (ex: T (representing 'afternoons' or M representi...
I'm using a Service-based Database (.MDF) to save some data from an application I'm developing. However, after I close the application, the data that was entered in the table disappears. Here is the code I'm using:
System.Data.SqlClient.SqlCon...