Thursday, March 10, 2022

How to enable dark mode in MS office (MS Excel)

 > First click on File

> Click on Option (screenshot given below)


> Than click on General

> Than click on Office Theme (Dark Grey) --- (Screenshot given below)


Reference:- https://www.howtogeek.com/360470/how-to-enable-dark-mode-in-microsoft-office/

Saturday, March 5, 2022

What is MVC in ASP.NET

 https://www.tutorialsteacher.com/mvc

How to change datatype of single or multiple column(s) in table in SQL server

For single column

 ALTER TABLE table_name

ALTER COLUMN column_name datatype;


----------------------------------------------------------------
For multiple columns

ALTER TABLE MST_TP_REGISTRATION ALTER COLUMN TP_Acct_Bene_Name VARCHAR(100) 

ALTER TABLE MST_TP_REGISTRATION ALTER COLUMN TP_Acct_Bene_Name_PAN VARCHAR(100)

What is XML

 XML is a extensible markup language. It is a markup language like HTML.  We can save it into .xml extension.


Example:-

<?xml version="1.0" encoding="UTF-8" ?>

<note>

    <to>

        Yash

    </to>

    <from>

        naveen

    </from>

</note>

What is ERP

 ERP is a Enterprise resource planning.

It is a system or software used for planning, manufacturing, financial and other process of an organization.