SQLrevisited
Blog to learn about SQL, database, Oracle, SQL Server, MySQL, PostgreSQL concepts and much more.
Saturday, August 13, 2022
How to find top 10 records from a table in Oracle, MySQL, and SQL Server? Examples
Sunday, July 31, 2022
How to convert String to Date in SQL Server and T-SQL? Example tutorial
While working with crude information, you may oftentimes confront date values put away as text. Changing these qualities over completely to a date information type is vital since dates might be more significant during examination. In SQL Server, switching a string over completely to date can be accomplished in various methodologies. In this article, we will cover various techniques to convert String to Date in all databases.
Sunday, June 12, 2022
10 Example of ALTER Clause in SQL
ALTER clause is one of the DDL commands which allows you to change object structure in database like table, stored procedure, trigger, or any other object in the database. By using ALTER command you can add or remove columns in a table, you can add and remove index from a table as well as you can update a stored procedure. ALTER command is an essential SQL commands for programmers similar to SELECT, UPDATE, and DELETE. If you know how to create a table or index then you should also know how to modify a table or index using ALTER command. In this article, we'll see some common ALTER table examples in SQL to learn this command better and become a better database developer.
Friday, May 13, 2022
How to use Stored Procedure in SQL or Database? Pros and Cons with Example
Hello folks if you want to learn about Stored Procedures in SQL and how it can help you to create a layer of abstraction around functionality then you have come to the right place. With the help of many examples, we will learn how to construct stored procedures in SQL Server.
Saturday, May 7, 2022
Difference between UNION and UNION ALL in SQL
Saturday, April 23, 2022
How to use WHERE and HAVING clause in SQL? Example Tutorial
Saturday, April 2, 2022
What are T-SQL window functions? How to use it and Performance Analysis
T-SQL window functions make creating a lot of queries easier, and they typically outperform previous approaches. Using the LAG function, for example, is far superior to doing a self-join. To improve overall performance, you must first comprehend the notion of framing and how window functions rely on sorting to provide results.