Trending questions in Database

0 votes
0 answers

Can PHP arrays hold items of different type?

The definition of an array in other ...READ MORE

Nov 16, 2022 in Database by Ashwini
• 5,430 points
985 views
0 votes
1 answer

Fatal error: Call to undefined function sqlsrv_connect()

This helped me get to my answer. There ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
3,734 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
• 63,600 points
3,719 views
0 votes
0 answers

I am having a forbidden error response when I try to login to Docker Desktop on a Windows OS

I am new to docker and I ...READ MORE

Nov 30, 2022 in Database by Gustave

edited Mar 4 27 views
0 votes
1 answer

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

The BIT datatype can be used to ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
3,181 views
0 votes
2 answers

How to send data to my database from html and css Contact Us Form?

Hello @Sign, It is simple to create contact ...READ MORE

Aug 4, 2020 in Database by Niroj
• 82,840 points
36,350 views
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

Feb 23, 2022 in Database by gaurav
• 23,260 points
11,858 views
0 votes
0 answers

Not all parameters were used in the SQL statement (Python, MySQL)

Error: mysql.connector.errors.ProgrammingError: Not all parameters were used in ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
3,551 views
0 votes
0 answers

Convert SQL to LINQ Query

I need to use the following SQL ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
3,988 views
0 votes
0 answers

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

I'm new to CakePHP and PHP. While ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
• 38,000 points
3,532 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

I think PreparedStatement would be a better choice. I ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
2,555 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

The lack of an underscore between "chartered" ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
2,766 views
0 votes
0 answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

After the selection in the select combo ...READ MORE

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

SQL Server string to date conversion

Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,600 points
2,662 views
0 votes
0 answers

Connection string using Windows Authentication

I'm building a website, however, I utilize ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,000 points
3,550 views
0 votes
1 answer

Is SQL syntax case sensitive?

The SQL keywords (SELECT, FROM, WHERE, etc.) ...READ MORE

Feb 16, 2022 in Database by Vaani
• 7,070 points
11,735 views
0 votes
1 answer

How do I do multiple CASE WHEN conditions using SQL Server 2008?

There are three formats of the case expression. ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
2,442 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
• 63,600 points
2,786 views
0 votes
0 answers

SUBSTR and INSTR SQL Oracle

I've begun utilising SUBSTR and INSTR in ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,000 points
3,367 views
0 votes
1 answer

Highest Salary in each department

SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
2,385 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
2,986 views
0 votes
0 answers

Error converting data type nvarchar to datetime SQL Server

I encountered this error: Error converting data type ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
3,827 views
0 votes
0 answers

Displaying ALL data from sqlite database into listview in tabbed activity

I've been struggling with this problem for ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
• 38,000 points
3,554 views
0 votes
1 answer

How do I limit the number of rows returned by an Oracle query after ordering?

Use a subquery for this like: select * from ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
2,486 views
0 votes
1 answer

How to Execute SQL Server Stored Procedure in SQL Developer?

You don't need EXEC clause. Simply use: proc_name ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,600 points
2,411 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

In addition to the advice already given, ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
2,315 views
0 votes
0 answers

How to display two digits after decimal point in SQL Server?

I want to return the value of ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,000 points
1,274 views
0 votes
1 answer

Multiple SQL Joins error in W3Schools Tryit Editor

I'm ruining this query on w3school even ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
2,244 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
• 63,600 points
2,512 views
0 votes
0 answers

Search text in stored procedure in SQL Server

I want to search all of my ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,000 points
3,131 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
2,316 views
0 votes
0 answers

How to store image in SQLite database

I want to upload an image from ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
3,242 views
0 votes
0 answers

SQLGrammarException: could not execute query

I'm using Struts 2 and Hibernate, and ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
3,286 views
0 votes
0 answers

Caused by: android.database.sqlite.SQLiteException: no such table: (code 1) Android

A SQLite database is present in our ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
3,140 views
0 votes
0 answers

SqlServer: Login failed for user

I created a pretty straightforward JDBC login ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,000 points
845 views
0 votes
1 answer

Maximum number of rows of CSV data in excel sheet

The maximum number of characters per cell ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,260 points
9,129 views
0 votes
0 answers

"This SqlTransaction has completed; it is no longer usable."... configuration error?

I've been working on this for about ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
• 38,000 points
3,243 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

How to drop multiple tables from one ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
• 38,000 points
3,328 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Use a simple-ish median calculation for a ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
1,738 views
0 votes
1 answer

How do I obtain a Query Execution Plan in SQL Server?

There are several ways to get an ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
1,694 views
0 votes
0 answers

Convert Month Number to Month Name Function in SQL

I have the months 1, 2, 3, ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
2,289 views
0 votes
0 answers

What is the purpose of using WHERE 1=1 in SQL statements?

Possible Duplicates: Why would a sql query have ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,000 points
2,586 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
• 63,600 points
1,949 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,260 points
9,288 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

The table name, column names, datatype, and ...READ MORE

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

org.hibernate.exception.SQLGrammarException:Could not execute JDBC batch update

I am using Hibernate to extract a ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,000 points
3,257 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

The majority of the responses to this ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
1,731 views
0 votes
1 answer

Java Apache POI Excel save as PDF

For the software to run, you'll need ...READ MORE

Mar 31, 2022 in Database by gaurav
• 23,260 points
8,914 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
• 63,600 points
1,828 views
0 votes
1 answer

Why do I need to configure the SQL dialect of a data source?

Dialect is defined as "a language's variety." ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
1,534 views