How to write SQL query in Visual Studio

How to execute SQL query in Visual Studio 2019.
Hi Guy’s here are the steps to writes SQL server query in visual studio . Let’s follow the steps.
step 1 : click Tools tab, click SQL Server –> New Query.

step 2 : select Local. select any available server. note SSMS must be installed. automatically Server Name taken.
Select Suitable authentication. 1. Windows Authentication (no need to give user name) select required database and press Connect button.

step 3 : if Authentication 2.SQL Server Authentication (give correct User Name) select required database and press Connect button.

step 5 : select required database from drop-down box . write any queries and execute.

Happy Query Thanks…

Post Author: adama