<

SQL - Inserting Data

Posted on
3,287 Points
0 Comments
187 Views
1 Endorsement
Last Modified:
Published
Experience Level: Beginner
5:14
Zia Syed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
1
Author:Zia Syed
0 Comments
Unpivotting by CROSS APPLY and VALUES
Article by: PortletPaul
Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
Table data compression, a multi-valuable database feature.
Article by: Tomas Helgi
Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the applicat…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month