Author Archives: Mandeep Singh

Like Clause SQL Server

Like Clause SQL Server Hi friends, in this post we will learn about Like Clause SQL Server. Like clause is used with where clause to search specified pattern on a column. There are two wildcard used in like clause. Percent sign:- % Underscore:- _ Earlier we had discussed about SQL AND & OR Operators, SQL Where

SQL AND & OR Operators

SQL AND & OR Operators Hi friends, in this post we will learn about SQL AND & OR Operators. AND & OR Operators is used to filter data from table based on one or more conditions. The AND operator displays a record if both the first condition AND the second condition are true. The OR operator displays

SQL Where Clause

SQL Where Clause Hi friends, in this post we will learn about SQL Where Clause or you can say Where Clause in SQL Server. SQL Server WHERE clause is used to specify a condition while fetching data from table. On given condition satisfaction then only it returns data from the table. WHERE clause is also used in UPDATE, DELETE

Delete Query SQL Server

Delete Query SQL Server Hi friends, in this post we will learn about Delete Query SQL Server or you can say Delete Query to Delete existing data rows from SQL server tables. SQL Delete Query can always used with conditions only. Earlier we had discussed about SQL Update Statement, SQL Select Statement, SQL Insert Statement, Drop Table SQL Server, Rename Table in SQL Server, Create Table

SQL Update Statement

SQL Update Statement Hi friends, in this post we will learn about SQL Update Statement or you can say Update Query to update existing data in SQL server tables. SQL Update Statement are used to update data rows in table. SQL Update Query can always used with conditions only. Earlier we had discussed about SQL Select Statement, SQL Insert Statement, Drop Table SQL Server, Rename Table in

SQL Select Statement

SQL Select Statement Hi friends, in this post we will learn about SQL Select Statement or you can say Select Query to get data from SQL server tables. SQL Select Statement are used to fetch data rows from table. In SQL Select Query we can also add conditions to get conditional data only. Earlier we had discussed about SQL Insert Statement, Drop Table