Trending questions in Database

0 votes
1 answer

Not equal <> != operator on NULL

Standard SQL-92 is represented by >; its ...READ MORE

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

Maximum number of rows of CSV data in excel sheet

The maximum number of characters per cell ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,260 points
7,707 views
0 votes
1 answer

How to check SQL Server version

Connect to the instance of SQL Server, ...READ MORE

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

What does the "@" symbol do in SQL?

The @CustID denotes a parameter for which ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 63,700 points
951 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,700 points
495 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,700 points
527 views
0 votes
0 answers

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm attempting to insert the number 1 ...READ MORE

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

Loop in stored procedure in SQL server

Writing a stored procedure that calls another ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,010 points
1,471 views
0 votes
0 answers

Android Studio, how to retrieve data from Sqlite database and display it into textview?

I built a SQLite Database and added ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,010 points
1,254 views
0 votes
1 answer

How can I use LTRIM/RTRIM to search and replace leading/trailing spaces?

Use LTRIM/RTRIM to eliminate spaces from the ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 63,700 points
897 views
0 votes
0 answers

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

The following code throws an exception when ...READ MORE

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

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

I am getting this JDBC exception. I ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,010 points
1,100 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,700 points
436 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,700 points
562 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,010 points
1,142 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,700 points
509 views
0 votes
1 answer

What does SELECT COUNT(1) from table_name on any database table mean

An expression to be tested for each ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,700 points
466 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,700 points
549 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,260 points
8,122 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,700 points
743 views
0 votes
0 answers

How to find server name of SQL Server Management Studio

Microsoft SQL Server 2008 is now installed. ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
• 38,010 points
1,013 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,010 points
1,094 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,700 points
552 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,700 points
746 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,010 points
1,039 views
0 votes
0 answers

The java.sql.SQLException: Fail to convert to internal representation

I want to do this query: String query ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
• 38,010 points
1,689 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,010 points
695 views
0 votes
1 answer

How to extract only the year from the date in sql server 2008?

To obtain the year from the given ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,700 points
561 views
0 votes
0 answers

Shortcut for changing the editor font size in Oracle SQL Developer

Is there a shortcut in Oracle SQL ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
1,357 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,010 points
1,080 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,700 points
451 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,700 points
443 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,010 points
1,533 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,700 points
392 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,700 points
598 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,700 points
618 views
0 votes
1 answer

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

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

Select Rows with id having even number

I'm passing a straightforward query that looks ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,010 points
1,536 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,700 points
522 views
0 votes
1 answer

Use of contains() in sql server

The straightforward method is shown here. You ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 63,700 points
657 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,010 points
909 views
0 votes
1 answer

Convert Number to Words in Indian currency format with paise value

Use this code and check  <?php /** ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
7,154 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,010 points
934 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,010 points
1,511 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,700 points
563 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,700 points
437 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,700 points
420 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,010 points
862 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,010 points
721 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,010 points
1,360 views