Most voted questions in Database

0 votes
0 answers

How to remove foreign key constraint in sql server?

In order to enter values of my ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,010 points • 722 views
0 votes
0 answers

Select Rows with id having even number

I'm passing a straightforward query that looks ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,010 points • 1,463 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,010 points • 2,613 views
0 votes
0 answers

Check if table exists in SQL Server

I want this to be the last ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,010 points • 33,682 views
0 votes
0 answers

How to import large sql file in phpmyadmin

I want to import a roughly 12-megabyte ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,010 points • 786 views
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Can you describe the ideas behind Covering ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,010 points • 309 views
0 votes
0 answers

SQL: Two select statements in one query

I want to return the newly created ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 5,306 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

When you add a new record to ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 1,450 views
0 votes
0 answers

Find the number of columns in a table

If a table's number of rows and ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 217 views
0 votes
0 answers

The java.sql.SQLException: Fail to convert to internal representation

I want to do this query: String query ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 1,644 views
0 votes
0 answers

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

For my production website, SQL Server 2008 ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 1,133 views
0 votes
0 answers

How to update two tables in one statement in SQL Server 2005?

In one operation, I want to update ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 461 views
0 votes
0 answers

How to get the connection String from a database

I want to use the database I ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 259 views
0 votes
0 answers

How to create a small and simple database using Oracle 11 g and SQL Developer?

How can I build a tiny, straightforward ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 453 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,010 points • 2,584 views
0 votes
0 answers

How to group by month from Date field using sql

How can I only group by month ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,010 points • 789 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,010 points • 2,390 views
0 votes
0 answers

How do I view the Explain Plan in Oracle Sql developer?

I want to check the query execution ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 1,032 views
0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

I have a table Emp which has these rows: Emp_cd ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 1,359 views
0 votes
0 answers

What is the purpose of Order By 1 in SQL select statement?

I discovered numerous views with an order ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 516 views
0 votes
0 answers

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I am getting this error: DECLARE * ERROR at line ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 801 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

I'm attempting to move data from the ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 1,363 views
0 votes
0 answers

SQL joins as venn diagram

I've had difficulties comprehending joins in SQL, ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 10,320 views
0 votes
0 answers

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

I am at a loss with one ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 1,218 views
0 votes
0 answers

SQL Server: Invalid Column Name

I am in the process of changing ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 1,121 views
0 votes
0 answers

Execution sequence of Group By, Having and Where clause in SQL Server?

I'm just not sure how a SQL ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 424 views
0 votes
0 answers

CROSS JOIN vs INNER JOIN in SQL

What is the difference between CROSS JOIN and INNER JOIN? CROSS ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 261 views
0 votes
0 answers

SQL Server Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Error: Cannot perform an aggregate function on an ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 950 views
0 votes
0 answers

Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

Given date: DECLARE @Date1 VARCHAR(50) = '30-01-2015' I want ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 5,774 views
0 votes
0 answers

Remove Identity from a column in a table

When we try to remove the identity ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 261 views
0 votes
0 answers

SQL TRUNCATE DATABASE ? How to TRUNCATE ALL TABLES

SQL Server 2008 R2 is what I ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 785 views
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,010 points • 4,492 views
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 535 views
0 votes
0 answers

What's the difference between Google Cloud Spanner and Cloud SQL?

I am new to the GCP stack ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 381 views
0 votes
0 answers

Export SQL query data to Excel

My query returns a huge amount of ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 410 views
0 votes
0 answers

How to Create a real one-to-one relationship in SQL Server?

I have two tables, Country and Capital, ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 321 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Using OJDBC 6, I created some Java ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 5,563 views
0 votes
0 answers

Where can I find the Northwind database for Microsoft SQL Server 2008

To hone my Linq-fu , I'm looking ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 346 views
0 votes
0 answers

How to Alter Constraint

My Constraint: CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode), I ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 303 views
0 votes
0 answers

Table Scan and Index Scan in SQL

What distinguishes a table scan from an ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 415 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,010 points • 2,837 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,010 points • 2,365 views
0 votes
0 answers

Display names of all constraints for a table in Oracle SQL

I have given each constraint a name ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 637 views
0 votes
0 answers

SQL to find the number of distinct values in a column

In a column, I can choose each ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 591 views
0 votes
0 answers

How to get Time from DateTime format in SQL?

I want to use a SQL query ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 649 views
0 votes
0 answers

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I'm attempting to create a Java EE ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 510 views
0 votes
0 answers

Adding an identity to an existing column

There are currently several rows in the ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 286 views
0 votes
0 answers

How to solve the system.data.sqlclient.sqlexception (0x80131904) error

I've used C# and SQL Server 2008 ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 10,062 views
0 votes
0 answers

Import .bak file to a database in SQL server

I have a file with .bak extension. How ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 275 views
0 votes
0 answers

Import CSV file into SQL Server

I have a few fundamental questions and ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 721 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.