In this post, we can discuss, how we can sum positive and negative numbers without subquery. The sum of a positive and negative integer is… Read More »SQL – Sum of positive and negative numbers without subquery
In this post, you will understand the difference between the stored procedure and trigger. Stored Procedure The stored procedure has contained a collection of SQL… Read More »Difference between stored procedure and trigger in SQL
In this article, we will discuss the AND operator in SQL Server. AND is the logical operator used to combine multiple Boolean expressions. Syntex: AND… Read More »SQL Server – AND Operator
In this article, you will learn the use of the where a clause in SQL Server Where clause is used to filter the records from… Read More »SQL Server WHERE
In this article, we are going to discuss the SQL order by clause and its uses Order by clause we use to sorting of the… Read More »SQL Server – ORDER BY Clause
This post will introduce you to the basic SELECT the statement, how to use the statement. SELECT on Table Database tables are used to store… Read More »SQL Server SELECT Clause
This is a very common issue we face in SQL server management. We can fix this issue in two ways Dropping the table and recreate… Read More »Save changes not permitted SQL server
In this article, we are going to discuss joins in SQL. joins is a very important topic in SQL. The basic use of joins is… Read More »Joins in sql – Inner, Left, Right, Full,Self and Cross/Cartesian Join
In this article, we are going to discuss the differences between function and stored procedure. Both stored procedure and function contain the set of SQL… Read More »Difference between function and stored procedure in SQL
SQL stands for Structural Query Language. SQL language we use for the different database-related operations. Using this language we can create a new database or… Read More »SQL: DDL, DQL, DML, DCL, and TCL Commands