Trending questions in Database

0 votes
0 answers

SQL Server FOR EACH Loop

SQL query: DECLARE @MyVar datetime = '1/1/2010' ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,000 points • 5,748 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,800 points • 37,674 views
0 votes
0 answers

why this error ? ERROR Cannot add or update a child row a foreign key constraint fails

create table per( sl_no int UNIQUE NOT ...READ MORE

Dec 13, 2022 in Database by abc
edited Mar 4, 2025 • 425 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,580 points • 12,977 views
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 • 1,466 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
 • 86,360 points • 3,928 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
 • 86,360 points • 4,058 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 • 4,592 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
 • 86,360 points • 3,970 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,580 points • 10,865 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
 • 86,360 points • 3,642 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 • 4,312 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 • 4,443 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, 2025 • 397 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 • 4,769 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 • 12,667 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 • 4,237 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 • 3,689 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 • 4,826 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
 • 86,360 points • 3,233 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 • 3,546 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 • 4,483 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
 • 86,360 points • 3,362 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 • 4,429 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
 • 86,360 points • 3,316 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 • 4,414 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 • 4,222 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
 • 86,360 points • 3,180 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 • 4,022 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 • 4,111 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
 • 86,360 points • 3,212 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
 • 86,360 points • 2,970 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Tally Data in Excel or PDF: How ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,580 points • 10,488 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 • 3,441 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,580 points • 10,282 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,928 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,476 views
0 votes
0 answers

java.sql.SQLIntegrityConstraintViolationException

When I use the save insert/update command, ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 4,400 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
 • 86,360 points • 2,954 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
 • 86,360 points • 2,662 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,580 points • 10,371 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 • 1,500 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,834 views
0 votes
1 answer

How to calculate student pass percentage in excel

Percentage formula in Excel In cell D2, type ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,580 points • 9,766 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
 • 86,360 points • 2,601 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 • 4,067 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 • 3,395 views
0 votes
1 answer

Convert Number to Words in Indian currency format with paise value

Use this code and check  <?php /** ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 23,580 points • 9,386 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,813 views
0 votes
0 answers

Comparing Dates in Oracle SQL

I'm attempting to get it to show ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 3,494 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.