Jave Lupango - CodeLife

Create Table in MSSQL using T-SQL Command/Statement

In this blog, I will show how to create Table in MS SQL using T-SQL command. explain how its works and why we need to […]

Use UNION Operator in SQL

In this blog, I will show how to use and where to use UNION in SQL. Explain How its work and why we need to use […]

Calling a Web Services or Rest API from T-SQL using MSXML

In this blog, I will show step by step how to call a Web Service or Rest API in your T-SQL. explain how its works […]

Common Table Expression (CTE) in SQL Query

A Common Table Expression also called CTE in short form, is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. The CTE can also be used in a View. In this article, we will see in detail how to create and use CTEs from our SQL Server.

use Sub-Query in SQL Query

In this blog, I will show step by step how to use SQL Sub-Query in SQL Query. explain how its works and why we need […]

Create SQL Views

A Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra security.