Questions by Kithuzzz

0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

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

How to execute function in SQL Server 2008

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

Calculate a Running Total in SQL Server

Sep 9, 2022 in Database • 3,098 views
0 votes
1 answer

Difference between EXISTS and IN in SQL?

Sep 9, 2022 in Database • 1,954 views
0 votes
1 answer

SQL Server WITH statement

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

How to convert date to a format `mm/dd/yyyy`

Sep 8, 2022 in Database • 7,102 views
0 votes
1 answer

Use of contains() in sql server

Sep 8, 2022 in Database • 2,398 views
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

Sep 8, 2022 in Database • 3,564 views
0 votes
1 answer

How can I use LTRIM/RTRIM to search and replace leading/trailing spaces?

Sep 8, 2022 in Database • 2,875 views
0 votes
1 answer

Get list of databases from SQL Server

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

What does the "@" symbol do in SQL?

Sep 8, 2022 in Database • 2,668 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

Sep 8, 2022 in Database • 7,797 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

Sep 8, 2022 in Database • 2,890 views
0 votes
1 answer

How do I run an sql query in php?

Sep 8, 2022 in Database • 1,911 views
0 votes
0 answers

Using If else in SQL Select statement

Sep 6, 2022 in Database • 1,530 views
0 votes
0 answers

How to concat two columns into one with the existing column name in mysql?

Sep 6, 2022 in Database • 1,832 views
0 votes
0 answers

How to return only the Date from a SQL Server DateTime datatype

Sep 6, 2022 in Database • 1,489 views
0 votes
0 answers

SQL update query using joins

Sep 6, 2022 in Database • 1,775 views
0 votes
0 answers

How to find server name of SQL Server Management Studio

Sep 6, 2022 in Database • 2,739 views
0 votes
0 answers

SQL Server® 2016, 2017 and 2019 Express full download

Sep 6, 2022 in Database • 1,633 views
0 votes
0 answers

com.microsoft.sqlserver.jdbc.SQLServerDriver not found error

Sep 6, 2022 in Database • 1,602 views
0 votes
0 answers

Direct link for downloading Microsoft SQL Server 2008 R2 Express SP2 without clicking any button?

Sep 6, 2022 in Database • 1,298 views
0 votes
0 answers

How can I add the sqlite3 module to Python?

Sep 6, 2022 in Database • 2,925 views
0 votes
0 answers

Use '=' or LIKE to compare strings in SQL?

Sep 6, 2022 in Database • 1,424 views
0 votes
0 answers

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

Sep 5, 2022 in Database • 3,668 views
0 votes
0 answers

Copy data into another table

Sep 5, 2022 in Database • 1,321 views
0 votes
0 answers

How to rename a table in SQL Server?

Sep 5, 2022 in Database • 1,819 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

Sep 5, 2022 in Database • 3,776 views
0 votes
0 answers

How to SUM two fields within an SQL query

Sep 5, 2022 in Database • 2,196 views
0 votes
0 answers

How do you create a yes/no boolean field in SQL server?

Sep 5, 2022 in Database • 2,223 views
0 votes
0 answers

How to generate a Guid in SQL Server?

Sep 5, 2022 in Database • 1,782 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

Sep 5, 2022 in Database • 4,078 views
0 votes
0 answers

MySQL error code: 1175 during UPDATE in MySQL Workbench

Sep 5, 2022 in Database • 3,139 views
0 votes
0 answers

What is the Oracle equivalent of SQL Server's IsNull() function?

Sep 4, 2022 in Database • 1,765 views
0 votes
0 answers

Create SQLite database in android

Sep 4, 2022 in Database • 1,294 views
0 votes
0 answers

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

Sep 4, 2022 in Database • 2,861 views
0 votes
0 answers

Convert Month Number to Month Name Function in SQL

Sep 4, 2022 in Database • 3,320 views
0 votes
0 answers

Insert multiple rows into single column

Sep 4, 2022 in Database • 2,467 views
0 votes
0 answers

SQL Error: ORA-00942 table or view does not exist

Sep 4, 2022 in Database • 1,976 views
0 votes
0 answers

Difference between Implicit Conversion and Explicit Conversion in SQL Server

Sep 4, 2022 in Database • 1,342 views
0 votes
0 answers

Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation

Sep 4, 2022 in Database • 2,458 views
0 votes
0 answers

How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2

Sep 4, 2022 in Database • 6,467 views
0 votes
0 answers

Add Foreign Key to existing table

Sep 3, 2022 in Database • 1,396 views
0 votes
0 answers

Dynamic Drop Down lists using ajax, sql and php

Sep 3, 2022 in Database • 3,007 views
0 votes
0 answers

Rename database name in sql server management studio 2014

Sep 3, 2022 in Database • 1,420 views
0 votes
0 answers

Efficiently convert rows to columns in sql server

Sep 3, 2022 in Database • 1,868 views
0 votes
0 answers

What is wrong with my SQL here? #1089 - Incorrect prefix key

Sep 3, 2022 in Database • 2,397 views
0 votes
0 answers

"CASE" statement within "WHERE" clause in SQL Server 2008

Sep 3, 2022 in Database • 1,517 views
0 votes
0 answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

Sep 3, 2022 in Database • 5,288 views
0 votes
0 answers

SQL server invalid object name - but tables are listed in SSMS tables list

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