Most voted questions in Database

0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 86,360 points
7,083 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 86,360 points
6,298 views
0 votes
1 answer

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

As a result of our chat, you ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 86,360 points
6,703 views
0 votes
0 answers

Query comparing dates in SQL

I have a table containing dates for ...READ MORE

Sep 12, 2022 in Database by Kithuzzz
• 38,000 points
1,165 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 86,360 points
7,218 views
0 votes
1 answer

How to display databases in Oracle 11g using SQL*Plus

A MySQL "database" can be compared to ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
4,021 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
7,154 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
1,201 views
0 votes
1 answer

How do I create a table based on another table

Although CREATE TABLE AS... SELECT does exist ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
1,348 views
0 votes
1 answer

Using RegEx in SQL Server

Because LIKE can be used instead of managed ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
1,336 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

CHAR is a fixed-length character data type, ...READ MORE

Apr 26, 2023 in Database by Kanav Chopra

edited Mar 5 1,136 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
7,434 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
4,911 views
0 votes
1 answer

Add a column with a default value to an existing table in SQL Server

Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
2,993 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
1,508 views
0 votes
1 answer

How to calculate percentage with a SQL statement

The following has passed my tests, and ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
6,646 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
8,411 views
0 votes
1 answer

Add primary key to existing table

You have to drop constraint and recreate ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
1,017 views
0 votes
1 answer

What datatype should be used for storing phone numbers in SQL Server 2005?

Does this include: International numbers? Extensions? Other information besides the ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,991 views
0 votes
1 answer

PL/MySQL does it exist?

Despite the fact that MySQL and PL/SQL ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,962 views
0 votes
1 answer

Difference between numeric, float and decimal in SQL Server

use the float or real data types only if the precision provided by decimal (up ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
2,757 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

The maximum-open-cursors error, also known as ORA-01000, ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points

edited Jul 5, 2023 by Khan Sarfaraz 4,298 views
0 votes
1 answer

How to execute function in SQL Server 2008

The function appears not to be being ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,251 views
0 votes
1 answer

Calculate a Running Total in SQL Server

The problem is that the SQL Server ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
2,193 views
0 votes
1 answer

Difference between EXISTS and IN in SQL?

Although the exists keyword can be used ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,186 views
0 votes
1 answer

SQL Server WITH statement

I'm going to guess because I don't ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,077 views
0 votes
1 answer

How to convert date to a format `mm/dd/yyyy`

My date of birth change READ MORE

Feb 23, 2023 in Database by anonymous

edited Mar 5 4,778 views
0 votes
1 answer

Use of contains() in sql server

The straightforward method is shown here. You ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,565 views
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

It denotes that the field is (a ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
2,093 views
0 votes
1 answer

How can I use LTRIM/RTRIM to search and replace leading/trailing spaces?

Use LTRIM/RTRIM to eliminate spaces from the ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,652 views
0 votes
1 answer

Get list of databases from SQL Server

Execute: SELECT name FROM master.sys.databases I hope this helps ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
973 views
0 votes
1 answer

What does the "@" symbol do in SQL?

The @CustID denotes a parameter for which ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,783 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
6,089 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

Make sure none of your other columns ...READ MORE

Feb 8, 2023 in Database by JPC

edited Mar 5 1,707 views
0 votes
1 answer

How do I run an sql query in php?

Try this: <?php $conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,196 views
0 votes
0 answers

Using If else in SQL Select statement

In my select statement, two columns will ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
947 views
0 votes
0 answers

How to concat two columns into one with the existing column name in mysql?

Using MySQL, I want to combine two ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
952 views
0 votes
0 answers

How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
770 views
0 votes
0 answers

SQL update query using joins

A value that is returned from a ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,137 views
0 votes
0 answers

How to find server name of SQL Server Management Studio

Microsoft SQL Server 2008 is now installed. ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,630 views
0 votes
0 answers

SQL Server® 2016, 2017 and 2019 Express full download

Previous versions of SQL Server Express were ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,145 views
0 votes
0 answers

com.microsoft.sqlserver.jdbc.SQLServerDriver not found error

I'm having the same issue as this thread. ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
989 views
0 votes
0 answers

Direct link for downloading Microsoft SQL Server 2008 R2 Express SP2 without clicking any button?

Do you know of a button-free direct ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
804 views
0 votes
0 answers

How can I add the sqlite3 module to Python?

Can someone please explain how to install ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,490 views
0 votes
0 answers

Use '=' or LIKE to compare strings in SQL?

There is a (nearly religious) debate over ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
859 views
0 votes
0 answers

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

I am getting this JDBC exception. I ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
1,961 views
0 votes
0 answers

Copy data into another table

How can I use SQL Server to ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
674 views
0 votes
0 answers

How to rename a table in SQL Server?

The SQL query that I have used is : ALTER ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
1,085 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

How can I quickly switch rows and ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
3,142 views
0 votes
0 answers

How to SUM two fields within an SQL query

The sum of two fields that are ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
1,539 views