SQL Archives - Page 181 of 519 - SQL Authority with Pinal Dave

MySQL – How to do Straight Join in MySQL?

March 12, 2014

In an earlier post, we have learnt a new type of join called NATURAL JOIN supported in MySQL. In this post will see another type of join called STRAIGHT_JOIN. STRAIGHT_JOIN is actually an INNER JOIN but it forces the order in which data should be processed. As per MySQL’s documentation…

SQL Contest – Win Amazon Gift Cards – Learn How to Get Started with ClustrixDB

March 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

It has been a long time since we contest where we can learn something new and win something cool. I reached out to the good folks of Clustrix with the request to help me to build a contest where readers can learn and explore new technology, while stand a good…

MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join

March 10, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Joins

As you know MySQL supports ANSI JOINs like INNER JOIN, OUTER JOIN, CROSS JOIN etc. Do you know that it supports NATURAL JOIN?. A NATURAL JOIN is a type of JOIN which automatically maps the similar columns from both the tables. Let us create the following tables CREATE TABLE items(item_id…

MySQL – Reset Row Number for Each Group – Partition By Row Number

March 9, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, Ranking Functions

In earlier post, we have learnt how to generate row number for each row using a variable as MySQL does not have any system function like SQLServer’s row_number() to generate the row number. In this post we will see how to reset row number for each group (Alternate method for…

MySQL – Generating Row Number for Each Row Using Variable

March 8, 2014

Pinal Dave

SQL

MySQL, Ranking Functions, SQL Scripts

MySQL does not have any system function like SQL Server’s row_number () to generate the row number for each row. However, it can be generated using the variable in the SELECT statement. Let us see how MySQL Generating Row Number.

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

March 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

A very common question which I often receive is – “How big my table name can be?” The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. Execute following stored procedure in SQL Server. EXEC sp_server_info It will return following resultset. attribute_id…

SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server

March 5, 2014

Pinal Dave

SQL

Devart, SQL Reports, SQL Utility

Modern opportunities of electronic document management systems can significantly simplify the process of decision-making at an enterprise. In this blog post we will learn about SQL Report Builder in dbForge Studio for SQL Server.