Recent questions tagged sql

0 votes
0 answers

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

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

Reset identity seed after deleting records in SQL Server

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

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 11,174 views
0 votes
0 answers

What's the difference between RANK() and DENSE_RANK() functions in oracle?

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

SQL Update from One Table to Another Based on a ID Match

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 2,731 views
0 votes
0 answers

Convert SQL to LINQ Query

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 4,706 views
0 votes
0 answers

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 3,481 views
0 votes
0 answers

HAVING without GROUP BY

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 3,050 views
0 votes
0 answers

Select Rows with id having even number

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 4,350 views
0 votes
0 answers

SQLGrammarException: could not execute query

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 5,056 views
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 1,582 views
+1 vote
0 answers

SQL: Two select statements in one query

Aug 20, 2022 in Database by Kithuzzz
 • 38,000 points • 7,833 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

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

Find the number of columns in a table

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

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

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

How to group by month from Date field using sql

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

"This SqlTransaction has completed; it is no longer usable."... configuration error?

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 5,536 views
0 votes
0 answers

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

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 2,738 views
0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 3,346 views
0 votes
0 answers

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

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

How to convert date into timestamp in SQL query?

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 2,913 views
0 votes
0 answers

SQL joins as venn diagram

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 14,115 views
0 votes
0 answers

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 2,496 views
0 votes
0 answers

SQL Server: Invalid Column Name

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 3,458 views
0 votes
0 answers

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

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

CROSS JOIN vs INNER JOIN in SQL

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

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

Aug 18, 2022 in Database by Kithuzzz
 • 38,000 points • 2,805 views
0 votes
0 answers

Remove Identity from a column in a table

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

SQL Server FOR EACH Loop

Aug 18, 2022 in Database by Kithuzzz
 • 38,000 points • 6,205 views
0 votes
0 answers

Export SQL query data to Excel

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

How to Create a real one-to-one relationship in SQL Server?

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

How to Alter Constraint

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

Table Scan and Index Scan in SQL

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

Error converting data type nvarchar to datetime SQL Server

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 5,380 views
0 votes
0 answers

Not all parameters were used in the SQL statement (Python, MySQL)

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 5,160 views
0 votes
0 answers

Display names of all constraints for a table in Oracle SQL

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

SQL to find the number of distinct values in a column

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

Adding an identity to an existing column

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

How to solve the system.data.sqlclient.sqlexception (0x80131904) error

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 13,818 views
0 votes
0 answers

Import CSV file into SQL Server

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 2,091 views
0 votes
0 answers

How can I select the first day of a month in SQL?

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

Left Join With Where Clause

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

DateTime2 vs DateTime in SQL Server

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

Oracle SQL: Update a table with data from another table

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 2,397 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 4,496 views
0 votes
0 answers

What represents a double in sql server?

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

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

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

Finding duplicate rows in SQL Server

Aug 13, 2022 in Data Science by Kithuzzz
 • 38,000 points • 2,388 views
0 votes
1 answer

Calculate time difference in minutes in SQL Server

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 2,587 views
0 votes
0 answers

Find stored procedure by name

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 1,559 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.