Android Studio primarily uses Java as the default language. To do that, you would have to use the JDBC drivers to communicate with SQL Server. Microsoft JDBC Driver for SQL Server
]. They would let you connect to the SQL engine installed, and then you can execute the queries on the server to get or insert the data.
Even then, once the application is compiled, that would be of no use. I would recommend that you use SQLite databases instead. Android has a native support for SQLite databases and that is the preferred data storage method in Android. You can learn how to store the data in Android SQLite databases and how to get that from the provided link. Saving Data in SQL Databases | Android Developers
If you still want to use SQL Server, I would recommend using an API to connect to the SQL Server database through. You are not going to install SQL Server on the Android itself, are you? :-)