Trending questions in Database

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,690 points • 8,134 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Many responses advise using mysql —version. But ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 860 views
0 votes
1 answer

IN Clause with NULL or IS NULL

An in statement will be parsed identically to field=val1 or ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 845 views
0 votes
1 answer

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Unfortunately, you have to utilize sysobjects/syscolumns to ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 63,600 points • 974 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Correctly use the  group by: select l.* from table ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 841 views
0 votes
1 answer

How do I create a table based on another table

Although CREATE TABLE AS... SELECT does exist ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 1,170 views
0 votes
1 answer

Using RegEx in SQL Server

Because LIKE can be used instead of managed ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 1,156 views
0 votes
1 answer

What does "DISTINCT ON (expression)" do?

The snippet from the Official documentation for PostgreSQL is ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,600 points • 976 views
0 votes
1 answer

Unpivot with column name

Your inquiry is quite near. The following ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,600 points • 967 views
0 votes
0 answers

How to SUM two fields within an SQL query

The sum of two fields that are ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 1,393 views
0 votes
0 answers

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

I use the following code in Python ...READ MORE

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

SQL server invalid object name - but tables are listed in SSMS tables list

I'm trying to develop a stored procedure ...READ MORE

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

How can I set an SQL Server connection string?

.NET DataProvider -- Standard Connection with username ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 819 views
0 votes
1 answer

What is the use of a cursor in SQL Server?

Instead of receiving a result set as ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 63,600 points • 1,049 views
0 votes
1 answer

How to upsert (update or insert) in SQL Server 2005

Try to check for existence: IF NOT EXISTS ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 63,600 points • 829 views
0 votes
1 answer

How to execute function in SQL Server 2008

The function appears not to be being ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,600 points • 1,102 views
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,222 views
0 votes
0 answers

Query comparing dates in SQL

I have a table containing dates for ...READ MORE

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

CASE .. WHEN expression in Oracle SQL

Use an IN clause. Example: SELECT status, CASE ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 63,600 points • 793 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 1,007 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

When you add a new record to ...READ MORE

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

Difference between EXISTS and IN in SQL?

Although the exists keyword can be used ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,600 points • 1,014 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,470 views
0 votes
0 answers

I want to use CASE statement to update some records in sql server 2005

UPDATE dbo.TestStudents SET LASTNAME = ( ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 1,337 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,932 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,512 views
0 votes
1 answer

How do I run an sql query in php?

Try this: <?php $conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 63,600 points • 1,012 views
0 votes
1 answer

SQL SELECT from multiple tables

Try this: SELECT p.pid, p.cid, p.pname, c1.name1, c2.name2 FROM ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,600 points • 721 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 • 8,024 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 • 1,781 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 • 1,105 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 • 941 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 • 854 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 • 2,216 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,185 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 • 996 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,759 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,174 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,031 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,478 views
0 votes
1 answer

How to calculate student pass percentage in excel

Percentage formula in Excel In cell D2, type ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 7,566 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,110 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 • 821 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,612 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 • 1,113 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 • 955 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 • 967 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,067 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,674 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,046 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.