Questions by Kithuzzz

0 votes
0 answers

Replacing NULL with 0 in a SQL server query

Aug 27, 2022 in Database • 1,044 views
0 votes
0 answers

Reset AutoIncrement in SQL Server after Delete

Aug 27, 2022 in Database • 1,853 views
0 votes
0 answers

SQL Server : Arithmetic overflow error converting expression to data type int

Aug 26, 2022 in Database • 2,139 views
0 votes
0 answers

Find max and second max salary for a employee table MySQL

Aug 26, 2022 in Database • 1,789 views
0 votes
0 answers

How to open .SQLite files

Aug 26, 2022 in Database • 1,030 views
0 votes
0 answers

SQL query for distinct professors and courses

Aug 26, 2022 in Database • 26,576 views
0 votes
0 answers

SqlServer: Login failed for user

Aug 26, 2022 in Database • 1,528 views
0 votes
0 answers

Merge 2 tables in SQL and save into 1 new table

Aug 26, 2022 in Database • 1,002 views
0 votes
1 answer

Difference of two date time in sql server

Aug 26, 2022 in Database • 1,378 views
0 votes
0 answers

How to display two digits after decimal point in SQL Server?

Aug 26, 2022 in Database • 1,978 views
0 votes
0 answers

Connection string using Windows Authentication

Aug 26, 2022 in Database • 4,140 views
0 votes
0 answers

Why do you create a View in a database?

Aug 26, 2022 in Database • 1,061 views
0 votes
0 answers

SQL query to select data between two dates and times

Aug 25, 2022 in Database • 2,982 views
0 votes
0 answers

SQL how to compare two tables for same data content?

Aug 25, 2022 in Database • 1,507 views
0 votes
0 answers

How to fetch the nth highest salary from a table without using TOP and sub-query?

Aug 25, 2022 in Database • 2,411 views
0 votes
0 answers

SQL Server Insert if not exists

Aug 25, 2022 in Database • 3,037 views
0 votes
0 answers

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

Aug 25, 2022 in Database • 1,473 views
0 votes
0 answers

Self Join to get employee manager name

Aug 25, 2022 in Database • 1,497 views
0 votes
0 answers

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

Aug 25, 2022 in Database • 1,357 views
0 votes
0 answers

When to use "ON UPDATE CASCADE"

Aug 25, 2022 in Database • 2,099 views
0 votes
0 answers

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

Aug 25, 2022 in Database • 1,637 views
0 votes
0 answers

How to Return Multiple Values from CASE clause in Where Condition

Aug 25, 2022 in Database • 2,997 views
0 votes
0 answers

Return date as ddmmyyyy in SQL Server

Aug 23, 2022 in Database • 2,255 views
0 votes
0 answers

Bulk Record Update with SQL

Aug 23, 2022 in Database • 1,482 views
0 votes
0 answers

How to select the last record of a table in SQL?

Aug 23, 2022 in Database • 2,057 views
0 votes
0 answers

How can I delete using INNER JOIN with SQL Server?

Aug 23, 2022 in Database • 1,508 views
0 votes
0 answers

The node to traverse cannot be null (Hibernate SQL)

Aug 23, 2022 in Database • 2,153 views
0 votes
0 answers

Altering column size in SQL Server

Aug 23, 2022 in Database • 1,319 views
0 votes
0 answers

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

Aug 22, 2022 in Database • 1,174 views
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

Aug 22, 2022 in Database • 1,354 views
0 votes
0 answers

Caused by: android.database.sqlite.SQLiteException: no such table: (code 1) Android

Aug 22, 2022 in Database • 4,257 views
0 votes
0 answers

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

Aug 22, 2022 in Database • 2,916 views
0 votes
0 answers

If else in stored procedure sql server

Aug 22, 2022 in Database • 1,755 views
0 votes
0 answers

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

Aug 22, 2022 in Database • 9,844 views
0 votes
0 answers

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

Aug 22, 2022 in Database • 977 views
0 votes
0 answers

How to store image in SQLite database

Aug 22, 2022 in Database • 3,853 views
0 votes
0 answers

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

Aug 22, 2022 in Database • 2,258 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"

Aug 22, 2022 in Database • 1,614 views
0 votes
0 answers

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Aug 22, 2022 in Database • 2,299 views
0 votes
0 answers

Get size of all tables in database

Aug 22, 2022 in Database • 1,317 views
0 votes
0 answers

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

Aug 22, 2022 in Database • 2,694 views
0 votes
0 answers

SQL Server Configuration Manager not found

Aug 22, 2022 in Database • 1,443 views
0 votes
0 answers

How to convert SQL Server's timestamp column to datetime format

Aug 21, 2022 in Database • 2,239 views
0 votes
0 answers

Convert SQL to LINQ Query

Aug 21, 2022 in Database • 4,432 views
0 votes
0 answers

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

Aug 21, 2022 in Database • 3,115 views
0 votes
0 answers

HAVING without GROUP BY

Aug 21, 2022 in Database • 2,729 views
0 votes
0 answers

How to remove foreign key constraint in sql server?

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

Select Rows with id having even number

Aug 21, 2022 in Database • 3,799 views
0 votes
0 answers

SQLGrammarException: could not execute query

Aug 21, 2022 in Database • 4,475 views
0 votes
0 answers

Check if table exists in SQL Server

Aug 21, 2022 in Database • 43,409 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.