We can use “xp_cmdshell” to run windows command, it also will return output.
We need to run the following SQL to enable “xp_cmdshell“

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO</span>

EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

Now we can map network drive via “xp_cmdshell“.
In the following example, we will temporarily map “Z:” to “\\WS01\Sources” as domain user “joeschoice\mssql-admin” with login password “P@ssw0rd”
When SQL Server or SQL service is restarted, this network drive will disconnect.

-- Create network drive
EXEC xp_cmdshell 'NET USE Z: "\\WS01\Sources" P@ssw0rd /USER:joeschoice\mssql-admin'

When we no need to use this network drive, remember to disconnect this by the following SQL.

EXEC xp_cmdshell 'NET USE Z: /delete'

How to map network drive in SSMS: