Trending questions in Database

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
 • 86,360 points • 1,604 views
0 votes
0 answers

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I've been attempting to solve a significant ...READ MORE

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

How do I query for all dates greater than a certain date in SQL Server?

I tried this: SELECT * FROM dbo.March2010 A WHERE ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 2,108 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,000 points • 2,486 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 • 2,561 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,869 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 • 1,696 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 • 1,771 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 • 2,455 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
 • 86,360 points • 1,578 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 • 2,031 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 • 1,857 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 • 1,642 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 • 2,095 views
0 votes
0 answers

Oracle SQL: Update a table with data from another table

Table 1: id name ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 2,135 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 • 1,949 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 • 2,720 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 • 1,729 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 • 1,651 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,769 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 • 1,733 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,000 points • 1,639 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
 • 86,360 points • 1,433 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 • 2,002 views
0 votes
0 answers

Display data from SQL database into php/ html table.

I want to display one of my ...READ MORE

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

How to make a query with group_concat in sql server ?

I am aware that the Group Concat ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 1,710 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 • 1,560 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 • 2,334 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 • 1,524 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 • 1,427 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,000 points • 2,261 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,000 points • 1,369 views
0 votes
1 answer

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

Feb 4, 2022 in Database by Neha
 • 9,020 points • 10,610 views
0 votes
0 answers

If else in stored procedure sql server

I have created a stored procedure as ...READ MORE

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

Rounding off to two decimal places in SQL

Minutes must be converted to hours and ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 2,487 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 • 1,426 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

Mar 25, 2022 in Database by Edureka
 • 13,690 points • 8,430 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 • 1,334 views
0 votes
0 answers

Self Join to get employee manager name

Hello, the columns in my employee table ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 1,776 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,000 points • 1,979 views
0 votes
0 answers

Cannot Connect to Server - A network-related or instance-specific error

I am getting this error when trying to ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 1,591 views
0 votes
0 answers

How to use index in select statement?

Let's imagine I established an index (idx ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 1,544 views
0 votes
0 answers

What is the difference between varchar and nvarchar?

Is it only that multibyte characters are ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 1,532 views
0 votes
0 answers

Get week day name from a given month, day and year individually in SQL Server

I'm attempting to get a day name ...READ MORE

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

Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"

I want to host a SQL server ...READ MORE

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

SQL how to compare two tables for same data content?

I have two tables, TableA and TableB, ...READ MORE

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

Rename database name in sql server management studio 2014

The database I use is called "ip ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 1,328 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
 • 86,360 points • 1,278 views
0 votes
0 answers

SQL-Server: The backup set holds a backup of a database other than the existing

My attempt to restore a SQL Server ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 1,493 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,000 points • 1,223 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.