Trending questions in Database

0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 22,940 points • 70,244 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
 • 6,380 points • 104,151 views
0 votes
1 answer

Insert date value in SQL table

Always use ANSI default string literal format for date i.e. YYYY-MM-DD like below. INSERT ...READ MORE

Feb 17, 2022 in Database by Neha
 • 8,940 points • 52,053 views
0 votes
1 answer

Excel convert column to comma separated

The CONCATENATE function in Excel can transform ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 22,940 points • 48,356 views
0 votes
1 answer

Save excel as pdf changing its orientation to horizontal

To begin, go to the page layout ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 22,940 points • 17,353 views
0 votes
1 answer

Add common prefix to all cells in Excel

Using the Concatenate Function in Excel, you ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 22,940 points • 13,001 views
0 votes
1 answer

Multiple rows to one comma-separated value in Sql Server

Test Data DECLARE @Table1 TABLE(ID INT, Value INT) INSERT ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 48,200 points • 4,043 views
0 votes
1 answer

SQL query - Dept and Employee table, some departments may not have managers

Yes, even though I like using JOINs, ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 48,200 points • 3,831 views
0 votes
0 answers

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This is my Stored procedure : CREATE PROCEDURE ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 26,220 points • 4,842 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 48,200 points • 3,060 views
0 votes
1 answer

SQL query to find third highest salary in company

The easiest way to work this out ...READ MORE

Feb 21, 2022 in Database by Neha
 • 8,940 points • 11,885 views
0 votes
0 answers

Get json object values and store as arrays

[ ['david','female','john','e6a33eee180b07e563d74fee8c2c66b8',1,1,'roger63'], ...READ MORE

Nov 16, 2022 in Database by Ashwini
 • 2,960 points • 152 views
0 votes
0 answers

Can PHP arrays hold items of different type?

The definition of an array in other ...READ MORE

Nov 16, 2022 in Database by Ashwini
 • 2,960 points • 128 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
 • 26,220 points • 3,515 views
0 votes
1 answer

Create enum in SQL Server

Just normalize your model properly: create table user_rank ( ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 48,200 points • 2,353 views
0 votes
0 answers

SQL query for distinct professors and courses

There is a database on instructors, departments, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 26,220 points • 3,127 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 48,200 points • 1,855 views
0 votes
1 answer

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

One of the services has not begun ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 1,983 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
 • 26,220 points • 3,098 views
0 votes
1 answer

Convert Date to Text without losing the format in Excel?

The steps are as follows: Copy the dates ...READ MORE

Apr 1, 2022 in Database by gaurav
 • 22,940 points • 9,020 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

The unique key in your database that ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 48,200 points • 1,402 views
0 votes
1 answer

SQL Error: ORA-01861: literal does not match format string 01861

Try replacing the string literal for date ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 1,655 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 1,298 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 1,290 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
 • 26,220 points • 2,572 views
0 votes
1 answer

How to convert date to a format `mm/dd/yyyy`

Your data is already in varchar, thus ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 48,200 points • 1,376 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 48,200 points • 910 views
0 votes
1 answer

SQL Server Error : String or binary data would be truncated

You're trying to write more data than ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 48,200 points • 1,093 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 48,200 points • 1,191 views
0 votes
1 answer

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

Just populate the field directly, using ordering ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 48,200 points • 806 views
0 votes
1 answer

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

First off, if you're starting a new ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 48,200 points • 885 views
0 votes
0 answers

How to decrypt a password from SQL server?

Use the following SQL Server 2000 query: select ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 26,220 points • 2,425 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 970 views
0 votes
0 answers

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

I'm new to CakePHP and PHP. While ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 26,220 points • 1,560 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 48,200 points • 985 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

How can I quickly switch rows and ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 26,220 points • 1,252 views
0 votes
1 answer

How to delete multiple rows in SQL where id = (x to y)

If you need to delete based on ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 48,200 points • 715 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

I think PreparedStatement would be a better choice. I ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 48,200 points • 552 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
 • 26,220 points • 1,274 views
0 votes
0 answers

How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2

To modify the format of a date ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 26,220 points • 1,222 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Try this: update b set code = ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 48,200 points • 511 views
0 votes
1 answer

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

As a result of our chat, you ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 48,200 points • 744 views
0 votes
0 answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

After the selection in the select combo ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 26,220 points • 1,194 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Use this: SELECT *FROM ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 48,200 points • 494 views
0 votes
1 answer

Multiple SQL Joins error in W3Schools Tryit Editor

I'm ruining this query on w3school even ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 48,200 points • 462 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 48,200 points • 690 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

The lack of an underscore between "chartered" ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 48,200 points • 529 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 48,200 points • 716 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Use a simple-ish median calculation for a ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 48,200 points • 277 views
0 votes
1 answer

How to display databases in Oracle 11g using SQL*Plus

A MySQL "database" can be compared to ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 48,200 points • 564 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.