Trending questions in Database

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 • 1,005 views
0 votes
0 answers

SQL Error: ORA-00942 table or view does not exist

I'm using SQL Developer, and after creating ...READ MORE

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

What's the difference between VARCHAR and CHAR?

Any Unicode data can be stored in ...READ MORE

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

How to convert SQL Server's timestamp column to datetime format

Is there a simple way to convert ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 1,653 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,000 points • 1,733 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,000 points • 1,341 views
0 votes
1 answer

How to download excel in response from api react.js

Create ReactJS project import React, { Component } ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 7,778 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,000 points • 1,427 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,600 points • 742 views
0 votes
0 answers

How do you create a yes/no boolean field in SQL server?

How should a yes/no, or boolean, field ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 942 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,600 points • 642 views
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,000 points • 1,000 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,000 points • 1,646 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,000 points • 867 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,000 points • 977 views
0 votes
0 answers

Vendor code 17002 to connect to SQLDeveloper

When using SQLDeveloper to connect to a ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 1,020 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,000 points • 1,353 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,600 points • 652 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,000 points • 851 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,000 points • 803 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,000 points • 761 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,000 points • 1,489 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,000 points • 789 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,000 points • 1,209 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,000 points • 891 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,000 points • 1,192 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,186 views
0 votes
0 answers

SQL Server PRINT SELECT (Print a select query result)?

I want to print a particular value; ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 1,916 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,000 points • 877 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,000 points • 1,476 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,000 points • 870 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,000 points • 1,385 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,000 points • 1,274 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,000 points • 1,741 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,000 points • 649 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,000 points • 639 views
0 votes
0 answers

SQLite in Android How to update a specific row

For a time now, I've been attempting ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,755 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,000 points • 796 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,000 points • 1,393 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,000 points • 1,389 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,000 points • 952 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,000 points • 1,252 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,000 points • 896 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,000 points • 888 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,000 points • 573 views
0 votes
0 answers

The node to traverse cannot be null (Hibernate SQL)

I'm using hibernate to run the following ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 1,161 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,000 points • 676 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,000 points • 973 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,000 points • 532 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.