Trending questions in Database

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,895 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
 • 86,360 points • 2,381 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,776 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 • 2,438 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

They are not the same thing. Consider these ...READ MORE

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

Default SQL Server Port

The default port of SQL server is 1433. READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 2,335 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 • 2,621 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 • 9,592 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE

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

Escape Character in SQL Server

You can escape quotation like this: select 'it''s ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 86,360 points • 2,019 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
 • 86,360 points • 2,047 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 • 2,321 views
0 votes
1 answer

How to download created excel file in node.js using exceljs

Download a sample Excel file using Node. ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 9,117 views
0 votes
0 answers

SQL Server Insert if not exists

I want to add data to my ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 2,926 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,000 points • 3,134 views
0 votes
0 answers

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102

I'm getting the SQLSTATE[HY093] error: Line 102 ...READ MORE

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

LIMIT 10..20 in SQL Server

The LIMIT clause is not included in ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 86,360 points • 2,066 views
0 votes
0 answers

Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?

I'm incredibly annoyed. Everything is wonderful with ...READ MORE

Sep 5, 2022 in Database by narikkadan
 • 86,360 points • 2,429 views
0 votes
0 answers

Dynamic Drop Down lists using ajax, sql and php

I have a code that is effective. ...READ MORE

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

How to find third or nᵗʰ maximum salary from salary table?

Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all ...READ MORE

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

PDOException SQLSTATE[HY000] [2002] No such file or directory

My (very basic) site appears to have ...READ MORE

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

How to Return Multiple Values from CASE clause in Where Condition

I have a condition where utilizing the ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 2,858 views
0 votes
0 answers

SQL query to select data between two dates and times

My table contains a [time] field that ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 2,856 views
0 votes
1 answer

How to add a Try/Catch to SQL Stored Procedure

See TRY...CATCH (Transact-SQL) CREATE PROCEDURE [dbo].[PL_GEN_PROVN_NO1] ...READ MORE

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

How to ALTER multiple columns at once in SQL Server

ALTER the data types of several columns in ...READ MORE

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

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 86,360 points • 1,820 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 • 2,143 views
0 votes
0 answers

Shortcut for changing the editor font size in Oracle SQL Developer

Is there a shortcut in Oracle SQL ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 2,742 views
0 votes
0 answers

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]

I have this Java program: MySQLConnectExample.java import java.sql.*; import java.util.Properties; public ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 2,990 views
0 votes
1 answer

Storing images in SQL Server?

Following extensive performance testing and analysis, the ...READ MORE

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

SQL Inner-join with 3 tables?

Try this: SELECT s.studentname , ...READ MORE

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

How to extract only the year from the date in sql server 2008?

To obtain the year from the given ...READ MORE

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

How can I create a unique constraint on my column (SQL Server 2008 R2)?

The "indexes and keys" dialogue, not the ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 86,360 points • 1,628 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,971 views
0 votes
1 answer

How to check SQL Server version

Connect to the instance of SQL Server, ...READ MORE

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

What does "DISTINCT ON (expression)" do?

The snippet from the Official documentation for PostgreSQL is ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 86,360 points • 1,770 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 • 2,041 views
0 votes
0 answers

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm attempting to insert the number 1 ...READ MORE

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

SQL query to insert datetime in SQL Server

Using the SQL query below, I want ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 2,546 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 • 2,108 views
0 votes
0 answers

Android Studio, how to retrieve data from Sqlite database and display it into textview?

I built a SQLite Database and added ...READ MORE

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

SQL server invalid object name - but tables are listed in SSMS tables list

I'm trying to develop a stored procedure ...READ MORE

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

SQL Server: Multiple table joins with a WHERE clause

It matters whether you place the filter ...READ MORE

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

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

The following code throws an exception when ...READ MORE

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

nsert into a table, data returned from reserved command

Hi, I want to insert in a table, ...READ MORE

Oct 18, 2022 in Database by Edvaldo
edited Mar 4, 2025 • 296 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,930 views
0 votes
1 answer

Finding duplicate values in a SQL table

SELECT name, email, COUNT(*) FROM ...READ MORE

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

Delete all the records

You can use this if you have ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 86,360 points • 1,396 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,931 views
0 votes
1 answer

Calculate time difference in minutes in SQL Server

SELECT  Diff = CASE DATEDIFF(HOUR, StartTime, EndTime)                     WHEN ...READ MORE

Oct 4, 2022 in Database by anonymous
edited Mar 5, 2025 • 1,871 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.