Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure. This tag refers to the standard language, not for questions about specific vendor extensions, like MySQL or Microsoft SQL Server, so if you think your question relates to ...
0
votes
0answers
13 views
comparing two tables and updating the column
I'm having two tables A and B . A is having one column as A1 and B is having two columns as B1,B2.
If the value is present in A1 and in B1 then the B2 column in table b is get updated as Y .
If the ...
0
votes
0answers
7 views
Oracle: “super-select” over few results amazingly slow
I needed to execute a select in Oracle 11G which looked like this:
select distinct p_date, column1, column2, ...
from table1 t1, table2 t2, ...
where (some join relations)
and t1.p_date > ...
0
votes
0answers
4 views
using c_str() in SQLBindParameter with ODBC3
In my application in sql request I set sting parameter "ReceivedFrom" with this code:
...
-1
votes
0answers
10 views
VBNET - Store all queries inside a module?
I have a quick question about VBNET, I'm currently using VS 2012 Express.
My question is, how do I store my queries in a module and then use it in form? I tried :
Module query
Public ...
0
votes
2answers
11 views
SQL Alias with Select
I have a table with 3 columns:
Voornaam Tussenvoegsel Achternaam
Armin van Buuren
(just an example name)
What I want to do now is select these 3 columns so I can use them ...
0
votes
3answers
44 views
Handling SQL data in C#
namespace iss_farmacie_spitali
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object ...
-1
votes
4answers
21 views
Set the value of a button to equal the answer of an SQL query
My code has a text input and submit button which on return hides that form and displays a new button, which works. The problem I'm having is setting the value of the button (or innerHTML) to the ...
-3
votes
1answer
22 views
syntax error, unexpected T_ELSE - PHP IF ELSE Database [closed]
I am trying to make an if-else construction for a (cake)PHP site. Basically, I want to compare 2 numbers from the database (participant_max and participant_current). If max=current, the button with ...
1
vote
0answers
29 views
Alternative to Rand() for large database [duplicate]
I have this query
$sql = mysql_query("SELECT DISTINCT a, b FROM table ORDER BY RAND() DESC limit 15");
Which worked great when my table has only a couple of rows, now my table has thousands this ...
0
votes
1answer
26 views
PHP: 01/01/1970 how to store a null or empty in a SQL datetime field
I need you wisdom.
I have a form. This form has a field to enter a date. The data from this form is stored in a table where it waits for approval and when the information from this table is approved ...
0
votes
0answers
35 views
Join Query on comma separated values
This is my 1st table :
this is another table on which i want to perform join operation :
i want to retrieve first_name for "activity_cc" column
For e.g: I want to show Pritam,Niket for ...
0
votes
3answers
26 views
GetDate() Function in T-SQL
My mind has gone totally blank this morning. I'm creating a proc and I need it to pull results with a date related WHERE clause. The where clause should state that the report should look back two ...
-1
votes
0answers
21 views
getting search result between minimum and maximum age in php mysql
I am making Search Page in my matrimonial site. where user can search users with photo and without photos along with Religion, cast, marital status and min and maximum age
...
0
votes
0answers
15 views
loop update statement in classic asp
I really need some help with this code. The loop is only making the update statement run once when there are maybe 4 records chosen so it has to loop 4 times. This is the 1st time ive come across this ...
2
votes
1answer
29 views
LINQPad - can't understand the query generated
I typed the following LINQ in LINQPad and using the connection to my database (SQL Server 2005) using dbcontext.
from j in Jobs
where j.dValuationDate.HasValue && j.dValuationDate.Value > ...
