Explore SQL on Experts Exchange

Expert Solutions for Your Tech Problems

SQLSQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....

Read more
  • 60K Content
  • 7.7K Contributors

Expert Spotlight
Microsoft Developer

Developer ´& Designer of Business Solutions based on SQL Server, Excel and Access

Troubleshooting Solution

Expand SQL statement to include the datatype with name of the field

46

I am looking to expand this query below so that each field returned has its datatype next to it,

Article

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Post

This is a cool tool to help visualize explain plans in …

This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Post

So excited for SQL Server 2017. …

So excited for SQL Server 2017.
Post

Sequential or Random Rows in Microsoft Access  Study my …

1
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Troubleshooting Solution

Adding different values from a table to find a specific sum value

251
There are times when I need to find a certain value out of a number of records. For example, assume …
Article
If Function

Understanding and Using PowerFX IF Function Effectively

In this post, I'll use examples to illustrate how the "If" function operates.
Post

It's interesting to see where the SQL co-creator sees …

It's interesting to see where the SQL co-creator sees similarities between SQL and NoSQL. …
Troubleshooting Solution

Count total number of sql table columns not empty

byJ Sung
28

An SQL table has many ID's (pk int). I guess that's a ROW?

Each ID has a column named RISK and BOXes

Article

A SQL Tidbit: Conditional Aggregates

17
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't
Article

Beware of Between

12
'Between' is such a common word we rarely think about it but in SQL it has a very specific …
Post

I haven't worked with SQL Server since 2001. Now I'm trying …

9
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Troubleshooting Solution

What is the URL for locally installed PHPMyAdmin?

94

I know I have that installed, but I forgot the URL.


Can someone remind me?


Thanks.

Troubleshooting Solution

Dynamic changing of dblink in Oracle sql

byRads R
137
How to concatenate dblink which will change dynamically in a Oracle SQL Statement at the end of the …
Troubleshooting Solution

DB2 SQL - find uptime values in a table

163
Hi all,

I have hundreds of identical tables - one for every hour:
        I_YEAR INTEGER NOT …
Troubleshooting Solution

Names of places in DK

158
My project is to create a service that helps users to find names of places in Denmark.

I use a …
Troubleshooting Solution

How to use Powershell data from SQL

byAckles
151
Hello,
This is in regards to question asked here:
Troubleshooting Solution

Dlookup problem

154
Based on the following print screen provided i am trying to do a Dlookup on that query (the tables …
Article

New SQL features on Oracle 21c Database

In this article we will see what new features are been release by Oracle for making SQL much efficient .

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more