Saturday, February 25, 2023

Changing NULL to NOT NULL of a Column Property  With  SQL Sever 2017 in Codes

Working with Database Management System (DBMS), we sometimes forgot some properties needed in a column while was creating a table. In this case, there is a Customer table which PositionID column needs to be changed from null to  not null property.

You can use keyword ALTER. Here is the example of the script.

ALTER TABLE Employee
ALTER COLUMN "PositionID"  TINYINT NOT NULL 




Don't forget, data type TINYINT still needs to be written after the column PositionID.


 

Saturday, February 18, 2023


CREATING ROUND BAR TIP OF THE COLUMN CHART IN POWERPOINT


Make sure the type of chart is 3-D Clustered Column.


Right click the chart -> Format Chart Area -> Chart Options -> Effects -> 3-D Rotation : X Rotation = 00; Y Rotation = 00; Perspective near to 00.

Choose the blue bar and then right click -> Format Data Series -> Effects -> 3-D Format -> Top Bevel : Width =10 pt; Height = 10 pt. Select Material : Flat


Apply the same way to 2 others : orange and grey bar. 
Finish.

Source :
https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-make-the-columns-in-my-column-chart-have/94d39e86-2298-4ee8-ba8e-5eaca3e97c66