Trending questions in Database

0 votes
0 answers

What is the advantage of using "Set NOCOUNT ON" in stored procedure's which are used in ssis packages?

While studying SQL Server's performance tuning concepts, ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 34,260 points • 123 views
0 votes
0 answers

SqlServer: Login failed for user

I created a pretty straightforward JDBC login ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 34,260 points • 206 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
 • 34,260 points • 417 views
0 votes
0 answers

Springframework.dao.InvalidDataAccessResourceUsageException hibernate.SQLGrammarException MySQLSyntaxErrorException

In an effort to figure out what's ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 34,260 points • 155 views
0 votes
0 answers

How to group by month from Date field using sql

How can I only group by month ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 34,260 points • 452 views
0 votes
0 answers

Create table (structure) from existing table

How to create a new table in ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 34,260 points • 107 views
0 votes
0 answers

If else in stored procedure sql server

I have created a stored procedure as ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 362 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
 • 34,260 points • 444 views
0 votes
0 answers

Real life example, when to use OUTER / CROSS APPLY in SQL

With a colleague, I've been researching CROSS/OUTER ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 34,260 points • 226 views
0 votes
0 answers

Select rows with same id but different value in another column

I've read numerous threads and tried for ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 34,260 points • 785 views
0 votes
0 answers

How can I delete using INNER JOIN with SQL Server?

In SQL Server 2008, I want to ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 34,260 points • 307 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
 • 34,260 points • 128 views
0 votes
0 answers

What is the syntax to drop a Stored Procedure in SQL Server 2000?

In SQL Server 2000, how do you ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 34,260 points • 203 views
0 votes
0 answers

How to fix Recovery Pending State in SQL Server Database?

How to fix Recovery Pending State in ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 34,260 points • 119 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,020 points • 8,022 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
 • 34,260 points • 99 views
0 votes
0 answers

Why do you create a View in a database?

When and why does a database owner ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 34,260 points • 140 views
0 votes
0 answers

DECODE function in SQL server

How can I use DECODE() function in ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 34,260 points • 94 views
0 votes
0 answers

SQL Server Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Error: Cannot perform an aggregate function on an ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 34,260 points • 461 views
0 votes
0 answers

Difference of two date time in sql server

Is there a method to use SQL ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 34,260 points • 111 views
0 votes
0 answers

How do I view the Explain Plan in Oracle Sql developer?

I want to check the query execution ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 34,260 points • 413 views
0 votes
0 answers

The node to traverse cannot be null (Hibernate SQL)

I'm using hibernate to run the following ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 34,260 points • 238 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
 • 34,260 points • 106 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
 • 34,260 points • 92 views
0 votes
0 answers

Self Join to get employee manager name

Hello, the columns in my employee table ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 34,260 points • 113 views
0 votes
0 answers

Altering column size in SQL Server

How to change the column size of ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 34,260 points • 196 views
0 votes
0 answers

SQL Server Configuration Manager not found

I cannot locate the SQL Server Configuration ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 235 views
0 votes
0 answers

Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"

I want to host a SQL server ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 222 views
0 votes
0 answers

ORA-01476: "divisor is equal to zero" for SQL query (Oracle 10g)

I'm creating a SQL query with Oracle ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 34,260 points • 80 views
0 votes
0 answers

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I am getting this error: DECLARE * ERROR at line ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 34,260 points • 334 views
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

A SQL Server database table has had ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 162 views
0 votes
0 answers

java.sql.SQLIntegrityConstraintViolationException

When I use the save insert/update command, ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 34,260 points • 626 views
0 votes
0 answers

Rounding off to two decimal places in SQL

Minutes must be converted to hours and ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 34,260 points • 730 views
0 votes
0 answers

SQLite in Android How to update a specific row

For a time now, I've been attempting ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 34,260 points • 626 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

How to drop multiple tables from one ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 34,260 points • 535 views
0 votes
0 answers

Get all table names of a particular database by SQL query?

I'm developing a program that can interact ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 103 views
0 votes
0 answers

Calculate time difference in minutes in SQL Server

I require the minutes-based time difference between ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 34,260 points • 524 views
0 votes
0 answers

How to update two tables in one statement in SQL Server 2005?

In one operation, I want to update ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 34,260 points • 211 views
0 votes
0 answers

Get week day name from a given month, day and year individually in SQL Server

I'm attempting to get a day name ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 34,260 points • 505 views
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 34,260 points • 280 views
0 votes
0 answers

Execution sequence of Group By, Having and Where clause in SQL Server?

I'm just not sure how a SQL ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 34,260 points • 240 views
0 votes
0 answers

Get size of all tables in database

A sizable SQL Server database has been ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 34,260 points • 99 views
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Can you describe the ideas behind Covering ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 34,260 points • 138 views
0 votes
0 answers

SQL TRUNCATE DATABASE ? How to TRUNCATE ALL TABLES

SQL Server 2008 R2 is what I ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 34,260 points • 262 views
0 votes
0 answers

What is the purpose of Order By 1 in SQL select statement?

I discovered numerous views with an order ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 34,260 points • 216 views
0 votes
0 answers

How to create a small and simple database using Oracle 11 g and SQL Developer?

How can I build a tiny, straightforward ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 34,260 points • 159 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
 • 34,260 points • 65 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 34,260 points • 611 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
 • 34,260 points • 212 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
 • 34,260 points • 320 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.