Questions by Kithuzzz

0 votes
0 answers

How to import large sql file in phpmyadmin

Aug 21, 2022 in Database • 1,446 views
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Aug 21, 2022 in Database • 1,242 views
+1 vote
0 answers

SQL: Two select statements in one query

Aug 20, 2022 in Database • 7,292 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

Aug 20, 2022 in Database • 2,465 views
0 votes
0 answers

Find the number of columns in a table

Aug 20, 2022 in Database • 930 views
0 votes
0 answers

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

Aug 20, 2022 in Database • 3,360 views
0 votes
0 answers

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

Aug 20, 2022 in Database • 2,374 views
0 votes
0 answers

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

Aug 20, 2022 in Database • 1,466 views
0 votes
0 answers

How to get the connection String from a database

Aug 20, 2022 in Database • 1,180 views
0 votes
0 answers

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

Aug 20, 2022 in Database • 1,993 views
0 votes
0 answers

Displaying ALL data from sqlite database into listview in tabbed activity

Aug 20, 2022 in Database • 4,508 views
0 votes
0 answers

How to group by month from Date field using sql

Aug 20, 2022 in Database • 1,714 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 4,827 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 2,263 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 2,862 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 1,399 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 2,444 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

Aug 19, 2022 in Database • 2,508 views
0 votes
0 answers

SQL joins as venn diagram

Aug 19, 2022 in Database • 13,607 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 2,150 views
0 votes
0 answers

SQL Server: Invalid Column Name

Aug 19, 2022 in Database • 2,418 views
0 votes
0 answers

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

Aug 19, 2022 in Database • 1,397 views
0 votes
0 answers

CROSS JOIN vs INNER JOIN in SQL

Aug 18, 2022 in Database • 1,288 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 • 2,390 views
0 votes
0 answers

Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

Aug 18, 2022 in Database • 7,153 views
0 votes
0 answers

Remove Identity from a column in a table

Aug 18, 2022 in Database • 960 views
0 votes
0 answers

SQL TRUNCATE DATABASE ? How to TRUNCATE ALL TABLES

Aug 18, 2022 in Database • 1,928 views
0 votes
0 answers

SQL Server FOR EACH Loop

Aug 18, 2022 in Database • 5,778 views
0 votes
0 answers

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

Aug 18, 2022 in Database • 1,525 views
0 votes
0 answers

What's the difference between Google Cloud Spanner and Cloud SQL?

Aug 18, 2022 in Database • 1,116 views
0 votes
0 answers

Export SQL query data to Excel

Aug 18, 2022 in Database • 1,187 views
0 votes
0 answers

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

Aug 18, 2022 in Database • 1,212 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Aug 15, 2022 in Database • 8,506 views
0 votes
0 answers

Where can I find the Northwind database for Microsoft SQL Server 2008

Aug 15, 2022 in Database • 1,120 views
0 votes
0 answers

How to Alter Constraint

Aug 15, 2022 in Database • 1,412 views
0 votes
0 answers

Table Scan and Index Scan in SQL

Aug 15, 2022 in Database • 1,287 views
0 votes
0 answers

Error converting data type nvarchar to datetime SQL Server

Aug 15, 2022 in Database • 4,875 views
0 votes
0 answers

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

Aug 15, 2022 in Database • 4,625 views
0 votes
0 answers

Display names of all constraints for a table in Oracle SQL

Aug 15, 2022 in Database • 1,420 views
0 votes
0 answers

SQL to find the number of distinct values in a column

Aug 15, 2022 in Database • 1,611 views
0 votes
0 answers

How to get Time from DateTime format in SQL?

Aug 15, 2022 in Database • 1,608 views
0 votes
0 answers

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

Aug 15, 2022 in Database • 1,409 views
0 votes
0 answers

Adding an identity to an existing column

Aug 14, 2022 in Database • 1,136 views
0 votes
0 answers

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

Aug 14, 2022 in Database • 12,571 views
0 votes
0 answers

Import .bak file to a database in SQL server

Aug 14, 2022 in Database • 1,167 views
0 votes
0 answers

Import CSV file into SQL Server

Aug 14, 2022 in Database • 1,754 views
0 votes
0 answers

Login to Microsoft SQL Server Error: 18456

Aug 14, 2022 in Database • 1,240 views
0 votes
0 answers

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

Aug 14, 2022 in Database • 1,493 views
0 votes
0 answers

Left Join With Where Clause

Aug 14, 2022 in Database • 1,423 views
0 votes
0 answers

DateTime2 vs DateTime in SQL Server

Aug 14, 2022 in Database • 1,224 views
Page:
"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.