questions/database/page/2
I experimented with the following code in ...READ MORE
After the selection in the select combo ...READ MORE
I'm studying Android. I'm having trouble solving ...READ MORE
SELECT * from games WHERE (lower(title) LIKE ...READ MORE
Try either multi-table update syntax: UPDATE config t1 ...READ MORE
There are no built-in functions for determining ...READ MORE
My (very basic) site appears to have ...READ MORE
This helped me get to my answer. There ...READ MORE
Using OJDBC 6, I created some Java ...READ MORE
To display the query string: print_r($this->db->last_query()); ...READ MORE
I've had difficulties comprehending joins in SQL, ...READ MORE
I was wondering if there was a ...READ MORE
Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE
A MySQL "database" can be compared to ...READ MORE
I'm ruining this query on w3school even ...READ MORE
The lack of an underscore between "chartered" ...READ MORE
I'm trying to create a time clock ...READ MORE
You can use OPENROWSET to import an Excel file ...READ MORE
SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY ...READ MORE
You don't need EXEC clause. Simply use: proc_name ...READ MORE
I need to use the following SQL ...READ MORE
Use a simple-ish median calculation for a ...READ MORE
The BIT datatype can be used to ...READ MORE
Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE
Use a subquery for this like: select * from ...READ MORE
I have a code that is effective. ...READ MORE
The maximum-open-cursors error, also known as ORA-01000, ...READ MORE
The "indexes and keys" dialogue, not the ...READ MORE
There are several ways to get an ...READ MORE
Option 1 is the only good solution. Why? Option ...READ MORE
There are three formats of the case expression. ...READ MORE
You can use this if you have ...READ MORE
You can escape quotation like this: select 'it''s ...READ MORE
Dialect is defined as "a language's variety." ...READ MORE
I'm incredibly annoyed. Everything is wonderful with ...READ MORE
An in statement will be parsed identically to field=val1 or ...READ MORE
In addition to the advice already given, ...READ MORE
Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all ...READ MORE
Correctly use the group by: select l.* from table ...READ MORE
The majority of the responses to this ...READ MORE
Many responses advise using mysql —version. But ...READ MORE
.NET DataProvider -- Standard Connection with username ...READ MORE
There is no LIKE & IN combination ...READ MORE
I have the months 1, 2, 3, ...READ MORE
Try to check for existence: IF NOT EXISTS ...READ MORE
An expression to be tested for each ...READ MORE
Using the SQL query below, I want ...READ MORE
In SQL Server 2012 and up you ...READ MORE
Connect to the instance of SQL Server, ...READ MORE
It matters whether you place the filter ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.