Most answered questions in Database

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,000 points
676 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,000 points
1,086 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,000 points
3,147 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,541 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,245 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
1,100 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,000 points
2,595 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,000 points
1,851 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
• 86,360 points
2,133 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,000 points
911 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,000 points
721 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,664 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,000 points
2,454 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,000 points
1,736 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,314 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,000 points
726 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,000 points
1,805 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,000 points
5,004 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
• 86,360 points
781 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,000 points
833 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,000 points
2,139 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,000 points
781 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,289 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,268 views
0 votes
0 answers

"CASE" statement within "WHERE" clause in SQL Server 2008

The query I'm working with has a ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,000 points
889 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
• 38,000 points
3,472 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,801 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
• 38,000 points
2,278 views
0 votes
0 answers

How can I get column names from a table in SQL Server?

I want to search for every column's ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,000 points
636 views
0 votes
0 answers

Auto increment primary key in SQL Server Management Studio 2012

How can I make a SQL Server ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,000 points
853 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,215 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,496 views
0 votes
0 answers

How to install SQL Server Management Studio 2012 (SSMS) Express?

I just set up SQL Server 2012 ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,000 points
644 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,210 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,280 views
0 votes
0 answers

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

In one ALTER TABLE statement, I would ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 38,000 points
1,198 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
1,149 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,000 points
1,931 views
0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

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

SQL-Server: The backup set holds a backup of a database other than the existing

My attempt to restore a SQL Server ...READ MORE

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

How do I get list of all tables in a database using TSQL?

How can I find out the names ...READ MORE

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

What is "Advanced" SQL?

Examining job postings where "advanced SQL" is ...READ MORE

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

Nested select statement in SQL Server

Why does the following not function? SELECT name ...READ MORE

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

Equivalent of Oracle's RowID in SQL Server

What does SQL Server's RowID resemble in ...READ MORE

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

How to use index in select statement?

Let's imagine I established an index (idx ...READ MORE

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

What is the difference between varchar and nvarchar?

Is it only that multibyte characters are ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
• 38,000 points
989 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
622 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
• 38,000 points
3,734 views
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
608 views
0 votes
0 answers

Backup a single table with its data from a database in sql server 2008

I want to use a script to ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,000 points
774 views