Most voted questions in Database

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,000 points
215 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,000 points
16,783 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,000 points
549 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,000 points
2,305 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,000 points
164 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,000 points
872 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,000 points
1,028 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,000 points
252 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,000 points
272 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,000 points
318 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,000 points
2,665 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,000 points
9,571 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,000 points
409 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,000 points
221 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,000 points
218 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,000 points
389 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,000 points
3,257 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,000 points
524 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,000 points
375 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,000 points
290 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,000 points
950 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,000 points
958 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,000 points
881 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,000 points
1,043 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,000 points
7,198 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,000 points
458 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,000 points
269 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,000 points
4,928 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,000 points
5,338 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,000 points
1,414 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,000 points
2,798 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,000 points
2,756 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,000 points
2,251 views
0 votes
0 answers

Query comparing dates in SQL

I have a table containing dates for ...READ MORE

Sep 12, 2022 in Database by Kithuzzz
• 38,010 points
376 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,000 points
2,829 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,000 points
1,330 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,000 points
3,312 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,000 points
217 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,000 points
205 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,000 points
419 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,000 points
235 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,000 points
1,048 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,000 points
1,655 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,000 points
1,259 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,000 points
548 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,000 points
2,383 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

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

Add primary key to existing table

You have to drop constraint and recreate ...READ MORE

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

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

Does this include: International numbers? Extensions? Other information besides the ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,000 points
714 views
0 votes
1 answer

PL/MySQL does it exist?

Despite the fact that MySQL and PL/SQL ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,000 points
360 views