Questions by Kithuzzz

0 votes
1 answer

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

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

How to execute function in SQL Server 2008

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

Calculate a Running Total in SQL Server

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

Difference between EXISTS and IN in SQL?

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

SQL Server WITH statement

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

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

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

Use of contains() in sql server

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

SQL keys, MUL vs PRI vs UNI

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

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

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

Get list of databases from SQL Server

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

What does the "@" symbol do in SQL?

Sep 8, 2022 in Database • 2,281 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,004 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

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

How do I run an sql query in php?

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

Using If else in SQL Select statement

Sep 6, 2022 in Database • 1,260 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,440 views
0 votes
0 answers

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

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

SQL update query using joins

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

How to find server name of SQL Server Management Studio

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

SQL Server® 2016, 2017 and 2019 Express full download

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

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

Sep 6, 2022 in Database • 1,354 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,077 views
0 votes
0 answers

How can I add the sqlite3 module to Python?

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

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

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

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

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

Copy data into another table

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

How to rename a table in SQL Server?

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

Simple way to transpose columns and rows in SQL?

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

How to SUM two fields within an SQL query

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

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

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

How to generate a Guid in SQL Server?

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

SQL Error: ORA-00913: too many values

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

MySQL error code: 1175 during UPDATE in MySQL Workbench

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

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

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

Create SQLite database in android

Sep 4, 2022 in Database • 1,027 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,170 views
0 votes
0 answers

Convert Month Number to Month Name Function in SQL

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

Insert multiple rows into single column

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

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

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

Difference between Implicit Conversion and Explicit Conversion in SQL Server

Sep 4, 2022 in Database • 1,048 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,182 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,022 views
0 votes
0 answers

Add Foreign Key to existing table

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

Dynamic Drop Down lists using ajax, sql and php

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

Rename database name in sql server management studio 2014

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

Efficiently convert rows to columns in sql server

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

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

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

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

Sep 3, 2022 in Database • 1,210 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 • 4,413 views
0 votes
0 answers

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

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