Trending questions in Database

0 votes
0 answers

Efficiently convert rows to columns in sql server

I need to deal with a lot ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,010 points
754 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
• 63,420 points
369 views
0 votes
0 answers

What is wrong with my SQL here? #1089 - Incorrect prefix key

CREATE TABLE `table`.`users` ( ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,010 points
753 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
• 63,420 points
428 views
0 votes
0 answers

How to fetch the nth highest salary from a table without using TOP and sub-query?

I was recently requested to create a ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
1,089 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,010 points
572 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,348 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,347 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,010 points
1,628 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,010 points
547 views
0 votes
0 answers

UPDATE and REPLACE part of a string

A table I have has two columns: ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,010 points
919 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
• 63,420 points
361 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,010 points
564 views
0 votes
0 answers

How to generate a Guid in SQL Server?

I have to make a SQL Id ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,010 points
546 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,010 points
1,714 views
0 votes
0 answers

When to use "ON UPDATE CASCADE"

I frequently use ON DELETE CASCADE, but ...READ MORE

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

Select data from date range between two dates

I have a database called Product Sales ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,010 points
664 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,010 points
461 views
0 votes
0 answers

How to create a table from select query result in SQL Server 2008

I tried to build a table from ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,010 points
630 views
0 votes
0 answers

Check if table exists and if it doesn't exist, create it in SQL Server 2008

I'm using SQL Server 2008 to create ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,010 points
627 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,670 points
7,086 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,010 points
431 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,204 views
0 votes
0 answers

Find max and second max salary for a employee table MySQL

Assume you are given the following straightforward ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
899 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,010 points
896 views
0 votes
1 answer

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

Mar 30, 2022 in Database by gaurav
• 23,260 points
7,370 views
0 votes
0 answers

Return date as ddmmyyyy in SQL Server

I require the date in the format ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
1,003 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,113 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,010 points
366 views
0 votes
0 answers

SQL Server : Arithmetic overflow error converting expression to data type int

I'm getting this error: msg 8115, level 16, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
824 views
0 votes
0 answers

Convert timestamp to date in Oracle SQL

How can we convert timestamp to date? READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,010 points
686 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,010 points
338 views
0 votes
0 answers

"CASE" statement within "WHERE" clause in SQL Server 2008

The query I'm working with has a ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,010 points
468 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,115 views
0 votes
0 answers

HAVING without GROUP BY

Does the following make sense in terms ...READ MORE

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

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

In one ALTER TABLE statement, I would ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,010 points
497 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,010 points
321 views
0 votes
0 answers

What is the Oracle equivalent of SQL Server's IsNull() function?

In SQL Server we can type IsNull() ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,010 points
393 views
0 votes
0 answers

SQL Update from One Table to Another Based on a ID Match

Account and credit card numbers are stored ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
946 views
0 votes
0 answers

Add Foreign Key to existing table

I want to add a Foreign Key ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,010 points
422 views
0 votes
0 answers

Select rows with same id but different value in another column

I've read numerous threads and tried for ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
• 38,010 points
1,366 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,010 points
286 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,010 points
327 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
7,098 views
0 votes
0 answers

Reset AutoIncrement in SQL Server after Delete

In a SQL Server database table, I ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
690 views
0 votes
0 answers

Equivalent of Oracle's RowID in SQL Server

What does SQL Server's RowID resemble in ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
• 38,010 points
549 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,019 views
0 votes
0 answers

Difference between Implicit Conversion and Explicit Conversion in SQL Server

Could you kindly explain the differences between ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,010 points
329 views
0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
• 38,010 points
540 views
0 votes
0 answers

MySQL Multiple Joins in one query?

I have the following query: SELECT dashboard_data.headline, ...READ MORE

Sep 4, 2022 in Database by narikkadan
• 63,420 points
324 views