questions/database
Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE
There were multiple issues. If you encounter ...READ MORE
As a result of our chat, you ...READ MORE
I have a table containing dates for ...READ MORE
This works quite well for SQL min/max dates ...READ MORE
A MySQL "database" can be compared to ...READ MORE
Try this: SELECT ... FROM ( SELECT ...READ MORE
Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE
Although CREATE TABLE AS... SELECT does exist ...READ MORE
Because LIKE can be used instead of managed ...READ MORE
CHAR is a fixed-length character data type, ...READ MORE
Option 1 is the only good solution. Why? Option ...READ MORE
You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE
Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE
Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE
The following has passed my tests, and ...READ MORE
Projection means choosing which columns (or expressions) the query shall ...READ MORE
You have to drop constraint and recreate ...READ MORE
Does this include: International numbers? Extensions? Other information besides the ...READ MORE
Despite the fact that MySQL and PL/SQL ...READ MORE
use the float or real data types only if the precision provided by decimal (up ...READ MORE
The maximum-open-cursors error, also known as ORA-01000, ...READ MORE
The function appears not to be being ...READ MORE
The problem is that the SQL Server ...READ MORE
Although the exists keyword can be used ...READ MORE
I'm going to guess because I don't ...READ MORE
My date of birth change READ MORE
The straightforward method is shown here. You ...READ MORE
It denotes that the field is (a ...READ MORE
Use LTRIM/RTRIM to eliminate spaces from the ...READ MORE
Execute: SELECT name FROM master.sys.databases I hope this helps ...READ MORE
The @CustID denotes a parameter for which ...READ MORE
I saw the problem in the line ...READ MORE
Make sure none of your other columns ...READ MORE
Try this: <?php $conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', ...READ MORE
In my select statement, two columns will ...READ MORE
Using MySQL, I want to combine two ...READ MORE
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part ...READ MORE
A value that is returned from a ...READ MORE
Microsoft SQL Server 2008 is now installed. ...READ MORE
Previous versions of SQL Server Express were ...READ MORE
I'm having the same issue as this thread. ...READ MORE
Do you know of a button-free direct ...READ MORE
Can someone please explain how to install ...READ MORE
There is a (nearly religious) debate over ...READ MORE
I am getting this JDBC exception. I ...READ MORE
How can I use SQL Server to ...READ MORE
The SQL query that I have used is : ALTER ...READ MORE
How can I quickly switch rows and ...READ MORE
The sum of two fields that are ...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.