Questions by Kithuzzz

0 votes
1 answer

How to get comma-separated values in multiple rows in SQL?

Sep 16, 2022 in Database • 59,105 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

Sep 16, 2022 in Database • 3,243 views
0 votes
1 answer

How to delete multiple rows in SQL where id = (x to y)

Sep 16, 2022 in Database • 7,737 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

Sep 16, 2022 in Database • 1,408 views
0 votes
1 answer

How to Execute SQL Server Stored Procedure in SQL Developer?

Sep 14, 2022 in Database • 3,415 views
0 votes
1 answer

SQL Server string to date conversion

Sep 14, 2022 in Database • 3,340 views
0 votes
1 answer

SQL SELECT from multiple tables

Sep 14, 2022 in Database • 1,378 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

Sep 14, 2022 in Database • 2,379 views
0 votes
1 answer

How to add a Try/Catch to SQL Stored Procedure

Sep 14, 2022 in Database • 2,050 views
0 votes
1 answer

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

Sep 14, 2022 in Database • 7,960 views
0 votes
1 answer

SQL query - Dept and Employee table, some departments may not have managers

Sep 14, 2022 in Database • 27,544 views
0 votes
1 answer

Storing images in SQL Server?

Sep 14, 2022 in Database • 1,939 views
0 votes
1 answer

What does "DISTINCT ON (expression)" do?

Sep 14, 2022 in Database • 2,286 views
0 votes
1 answer

Unpivot with column name

Sep 14, 2022 in Database • 1,490 views
0 votes
1 answer

SQL Inner-join with 3 tables?

Sep 13, 2022 in Database • 1,994 views
0 votes
1 answer

SQL Server Error : String or binary data would be truncated

Sep 13, 2022 in Database • 7,295 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

Sep 13, 2022 in Database • 2,509 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

Sep 13, 2022 in Database • 2,207 views
0 votes
1 answer

How to extract only the year from the date in sql server 2008?

Sep 13, 2022 in Database • 2,009 views
0 votes
1 answer

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

Sep 13, 2022 in Database • 4,083 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

Sep 13, 2022 in Database • 2,975 views
0 votes
1 answer

How do I limit the number of rows returned by an Oracle query after ordering?

Sep 13, 2022 in Database • 3,249 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

Sep 13, 2022 in Database • 4,002 views
0 votes
1 answer

Create enum in SQL Server

Sep 13, 2022 in Database • 22,214 views
0 votes
1 answer

Default SQL Server Port

Sep 12, 2022 in Database • 2,451 views
0 votes
1 answer

What is the use of a cursor in SQL Server?

Sep 12, 2022 in Database • 1,694 views
0 votes
1 answer

SQL Error: ORA-01861: literal does not match format string 01861

Sep 12, 2022 in Database • 18,472 views
0 votes
1 answer

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Sep 12, 2022 in Database • 16,736 views
0 votes
1 answer

Fatal error: Call to undefined function sqlsrv_connect()

Sep 12, 2022 in Database • 5,017 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Sep 12, 2022 in Database • 8,311 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

Sep 12, 2022 in Database • 7,246 views
0 votes
1 answer

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

Sep 12, 2022 in Database • 7,520 views
0 votes
0 answers

Query comparing dates in SQL

Sep 12, 2022 in Database • 1,478 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

Sep 12, 2022 in Database • 8,550 views
0 votes
1 answer

How to display databases in Oracle 11g using SQL*Plus

Sep 11, 2022 in Database • 4,917 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Sep 11, 2022 in Database • 8,130 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Sep 11, 2022 in Database • 1,621 views
0 votes
1 answer

How do I create a table based on another table

Sep 11, 2022 in Database • 1,813 views
0 votes
1 answer

Using RegEx in SQL Server

Sep 11, 2022 in Database • 1,764 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

Sep 11, 2022 in Database • 1,587 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Sep 11, 2022 in Database • 8,424 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

Sep 11, 2022 in Database • 6,281 views
0 votes
1 answer

Add a column with a default value to an existing table in SQL Server

Sep 11, 2022 in Database • 3,586 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Sep 11, 2022 in Database • 2,134 views
0 votes
1 answer

How to calculate percentage with a SQL statement

Sep 10, 2022 in Database • 7,473 views
0 votes
1 answer

What are projection and selection?

Sep 10, 2022 in Database • 10,085 views
0 votes
1 answer

Add primary key to existing table

Sep 10, 2022 in Database • 1,391 views
0 votes
1 answer

What datatype should be used for storing phone numbers in SQL Server 2005?

Sep 10, 2022 in Database • 2,477 views
0 votes
1 answer

PL/MySQL does it exist?

Sep 10, 2022 in Database • 2,610 views
0 votes
1 answer

Difference between numeric, float and decimal in SQL Server

Sep 10, 2022 in Database • 3,747 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.