Most voted questions in Database

0 votes
1 answer

Difference between numeric, float and decimal in SQL Server

use the float or real data types only if the precision provided by decimal (up ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,000 points • 671 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

The maximum-open-cursors error, also known as ORA-01000, ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,000 points • 1,089 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,000 points • 347 views
0 votes
1 answer

Calculate a Running Total in SQL Server

The problem is that the SQL Server ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,000 points • 530 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,000 points • 245 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,000 points • 172 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
 • 63,000 points • 2,559 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,000 points • 244 views
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

It denotes that the field is (a ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 63,000 points • 620 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,000 points • 436 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,000 points • 196 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,000 points • 367 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
 • 63,000 points • 1,824 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

Try this ALTER TABLE `users` ADD `id` INT ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 63,000 points • 489 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,000 points • 201 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,010 points • 143 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,010 points • 234 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,010 points • 190 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,010 points • 187 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 • 547 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,010 points • 295 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,010 points • 397 views
0 votes
0 answers

Direct link for downloading Microsoft SQL Server 2008 R2 Express SP2 without clicking any button?

Do you know of a button-free direct ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
 • 38,010 points • 215 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,010 points • 348 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,010 points • 194 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 • 642 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,010 points • 193 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,010 points • 356 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
 • 38,010 points • 1,868 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 • 642 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 • 487 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,010 points • 366 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

The table name, column names, datatype, and ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 38,010 points • 654 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 • 640 views
0 votes
0 answers

Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?

I'm incredibly annoyed. Everything is wonderful with ...READ MORE

Sep 5, 2022 in Database by narikkadan
 • 63,000 points • 1,012 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,010 points • 222 views
0 votes
0 answers

Create SQLite database in android

In my project, I want to construct ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,010 points • 172 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 • 751 views
0 votes
0 answers

Convert Month Number to Month Name Function in SQL

I have the months 1, 2, 3, ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,010 points • 1,066 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 • 636 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 • 459 views
0 votes
0 answers

Difference between Implicit Conversion and Explicit Conversion in SQL Server

Could you kindly explain the differences between ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,010 points • 193 views
0 votes
0 answers

Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation

If I try to change a column ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,010 points • 758 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
 • 38,010 points • 2,222 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
 • 63,000 points • 187 views
0 votes
0 answers

Add Foreign Key to existing table

I want to add a Foreign Key ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 179 views
0 votes
0 answers

Dynamic Drop Down lists using ajax, sql and php

I have a code that is effective. ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 1,222 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,010 points • 202 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,010 points • 579 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,010 points • 480 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.