Trending questions in Database

0 votes
0 answers

SQL multiple column ordering

How can I sort in several ways ...READ MORE

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

Replacing NULL with 0 in a SQL server query

I created a query, and the first ...READ MORE

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

Describe table structure

Which SQL query returns the table structure ...READ MORE

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

Which datatype to use to store a mobile number?

Which datatype will I use to store ...READ MORE

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

How can I select the first day of a month in SQL?

I only need to choose the given ...READ MORE

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

Merge 2 tables in SQL and save into 1 new table

I have two tables with the same columns. Table ...READ MORE

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

SQL: IF clause within WHERE clause

In MS SQL, is it feasible to ...READ MORE

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

CROSS JOIN vs INNER JOIN in SQL

What is the difference between CROSS JOIN and INNER JOIN? CROSS ...READ MORE

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

How to get the connection String from a database

I want to use the database I ...READ MORE

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

How to open .SQLite files

On Windows, I'm attempting to open an ...READ MORE

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

How can prepared statements protect from SQL injection attacks?

In what ways do prepared statements aid ...READ MORE

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

How to Alter Constraint

My Constraint: CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode), I ...READ MORE

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

Left Join With Where Clause

I need to take all of the ...READ MORE

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

How can I set a custom date time format in Oracle SQL Developer?

Date values are shown in Oracle SQL ...READ MORE

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

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I'm attempting to create a Java EE ...READ MORE

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

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can someone provide examples and a description ...READ MORE

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

Display names of all constraints for a table in Oracle SQL

I have given each constraint a name ...READ MORE

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

Export SQL query data to Excel

My query returns a huge amount of ...READ MORE

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

SQL use CASE statement in WHERE IN clause

Can you use a case statement in ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 1,695 views
0 votes
1 answer

Generating username from first name and last name in excel

How to automatically merge first and last ...READ MORE

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

How can I show the table structure in SQL Server query?

Query: SELECT DateTime, Skill, Name, TimeZone, ID, User, ...READ MORE

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

Table Scan and Index Scan in SQL

What distinguishes a table scan from an ...READ MORE

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

How to Create a real one-to-one relationship in SQL Server?

I have two tables, Country and Capital, ...READ MORE

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

Update Query with INNER JOIN between tables in 2 different databases on 1 server

Both databases are on the same server. db1 ...READ MORE

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

What's the difference between Google Cloud Spanner and Cloud SQL?

I am new to the GCP stack ...READ MORE

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

Scott account locked in SQL Plus

Scott is my username and tiger is ...READ MORE

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

What's the difference between RANK() and DENSE_RANK() functions in oracle?

What distinguishes the functions RANK() and DENSE ...READ MORE

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

Adding an identity to an existing column

There are currently several rows in the ...READ MORE

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

Find the number of columns in a table

If a table's number of rows and ...READ MORE

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

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

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

Query to check index on a table

I want a query to see if ...READ MORE

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

What represents a double in sql server?

I have several properties in C# which ...READ MORE

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

Find stored procedure by name

Is there a way to search for ...READ MORE

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

Import .bak file to a database in SQL server

I have a file with .bak extension. How ...READ MORE

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

Login to Microsoft SQL Server Error: 18456

When I try to connect to the SQL ...READ MORE

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

DateTime2 vs DateTime in SQL Server

Which one: datetime datetime2 is the recommended way to store date and ...READ MORE

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

Creating a new database and new connection in Oracle SQL Developer

I've introduced SQL Developer to my framework. ...READ MORE

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

How to export and import a .sql file from command line with options?

I need to commodity and import a ...READ MORE

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

Creating tables in sqlite database on android

@Override ...READ MORE

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

Where can I find the Northwind database for Microsoft SQL Server 2008

To hone my Linq-fu , I'm looking ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 1,268 views
0 votes
1 answer

Is Excel Alt+Enter same as Newline character \n ?

According to the excel documentation, pressing alt+enter ...READ MORE

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

Remove Identity from a column in a table

When we try to remove the identity ...READ MORE

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

How do I list all the columns in a table?

For the various popular database systems, how ...READ MORE

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

How to run SQL script in MySQL?

I want to use MySQL to run ...READ MORE

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

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL ...READ MORE

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

SQL Injection Exploiting Login form

I was pondering while at the same ...READ MORE

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

Removing leading zeroes from a field in a SQL statement

I'm dealing with a SQL question that ...READ MORE

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

What's the difference between TRUNCATE and DELETE in SQL

What distinguishes SQL's TRUNCATE and DELETE operations? Please ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,141 views
0 votes
1 answer

Converting Excel Date Serial Number to Date using Javascript

Please do try this : function ExcelDateToJSDate(serial) { ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 25,260 points • 5,996 views
0 votes
0 answers

Laravel - Datatables export excel from filtered data

Hello i would like to export data ...READ MORE

Mar 28, 2022 in Database by Edureka
 • 13,690 points • 6,455 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.