Most answered questions in Database

0 votes
1 answer

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Unfortunately, you have to utilize sysobjects/syscolumns to ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
468 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
3,156 views
0 votes
1 answer

How to print SQL statement in codeigniter model

To display the query string: print_r($this->db->last_query()); ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
3,112 views
0 votes
1 answer

SQL - Update multiple records in one query

Try either multi-table update syntax: UPDATE config t1 ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
3,061 views
0 votes
1 answer

Finding duplicate values in a SQL table

SELECT name, email, COUNT(*) FROM ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
642 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
434 views
0 votes
1 answer

Multiple rows to one comma-separated value in Sql Server

Test Data DECLARE @Table1 TABLE(ID INT, Value INT) INSERT ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
35,898 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

In addition to the advice already given, ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
1,316 views
0 votes
1 answer

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

If you need to delete based on ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
4,747 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

Use an IN clause. Example: SELECT status, CASE ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,420 points
315 views
0 votes
1 answer

How to Execute SQL Server Stored Procedure in SQL Developer?

You don't need EXEC clause. Simply use: proc_name ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
1,637 views
0 votes
1 answer

SQL Server string to date conversion

Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
1,941 views
0 votes
1 answer

SQL SELECT from multiple tables

Try this: SELECT p.pid, p.cid, p.pname, c1.name1, c2.name2 FROM ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
410 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

They are not the same thing. Consider these ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
549 views
0 votes
1 answer

How to add a Try/Catch to SQL Stored Procedure

See TRY...CATCH (Transact-SQL) CREATE PROCEDURE [dbo].[PL_GEN_PROVN_NO1] ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
679 views
0 votes
1 answer

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

First off, if you're starting a new ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
4,387 views
0 votes
1 answer

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

Yes, even though I like using JOINs, ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
17,919 views
0 votes
1 answer

Storing images in SQL Server?

Following extensive performance testing and analysis, the ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
744 views
0 votes
1 answer

What does "DISTINCT ON (expression)" do?

The snippet from the Official documentation for PostgreSQL is ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
402 views
0 votes
1 answer

Unpivot with column name

Your inquiry is quite near. The following ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
497 views
0 votes
1 answer

SQL Inner-join with 3 tables?

Try this: SELECT s.studentname , ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
780 views
0 votes
1 answer

SQL Server Error : String or binary data would be truncated

You're trying to write more data than ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
5,282 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

The majority of the responses to this ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
873 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

The LIMIT clause is not included in ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
884 views
0 votes
1 answer

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

To obtain the year from the given ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
482 views
0 votes
1 answer

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

The BIT datatype can be used to ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,807 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,576 views
0 votes
1 answer

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

Use a subquery for this like: select * from ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,649 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

The lack of an underscore between "chartered" ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,657 views
0 votes
1 answer

Create enum in SQL Server

Just normalize your model properly: create table user_rank ( ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
14,706 views
0 votes
1 answer

Default SQL Server Port

The default port of SQL server is 1433. READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
869 views
0 votes
1 answer

What is the use of a cursor in SQL Server?

Instead of receiving a result set as ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
468 views
0 votes
1 answer

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

Try replacing the string literal for date ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
11,603 views
0 votes
1 answer

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

One of the services has not begun ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
10,616 views
0 votes
1 answer

Fatal error: Call to undefined function sqlsrv_connect()

This helped me get to my answer. There ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
2,616 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
5,234 views
0 votes
1 answer

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

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
4,595 views
0 votes
1 answer

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

As a result of our chat, you ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
4,556 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

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,420 points
4,947 views
0 votes
1 answer

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

A MySQL "database" can be compared to ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
2,451 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
5,387 views
0 votes
1 answer

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

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
353 views
0 votes
1 answer

How do I create a table based on another table

Although CREATE TABLE AS... SELECT does exist ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
536 views
0 votes
1 answer

Using RegEx in SQL Server

Because LIKE can be used instead of managed ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
689 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

Any Unicode data can be stored in ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
386 views
0 votes
1 answer

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

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
4,960 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
2,990 views
0 votes
1 answer

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

Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
1,997 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

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
832 views
0 votes
1 answer

How to calculate percentage with a SQL statement

The following has passed my tests, and ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
4,739 views