My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: [ Ссылка ]
98-364: Database Fundamentals (Microsoft SQL Server): [ Ссылка ]
70-462 SQL Server Database Administration (DBA): [ Ссылка ]
Microsoft SQL Server Reporting Services (SSRS): [ Ссылка ]
SQL Server Integration Services (SSIS): [ Ссылка ]
SQL Server Analysis Services (SSAS): [ Ссылка ]
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): [ Ссылка ]
----
In this view, we have the following views:
CREATE VIEW view1 as
SELECT object_id, name, create_date, schema_id
FROM sys.objects
WHERE object_ID BETWEEN 1 AND 9
GO
CREATE VIEW view2 AS
SELECT object_id, name, modify_date, schema_id
FROM sys.objects
WHERE object_ID BETWEEN 6 AND 17
GO
----
Each of these videos have got 6 rows, 4 of which are in both views.
In this video, I am going to merge these 2 views together, so that there is a total of 8 views. However, there will also be 8 columns, such as 2 object_id columns and 2 name columns. There will be a lot of NULLs where the rows are not in both views.
The next task is to merge the two object_id columns together, so that we get rid of the NULLs and have just one object_id.
In this video, I will use three different ways of doing this, using the CASE, ISNULL and CASE WHEN ... IS NULL.
