SQL
If you want to select data from a table located in another database (but on the same server) using a SELECT statement, you can specify the database name in your query. In this case, your table is in the "SQL Tutorial" database, and you can use the following SQL syntax:
SELECT *
FROM [DatabaseName].[SchemaName].[TableName];
[DatabaseName]: Replace this with the name of the remote database where the table is located, which is "SQL Tutorial" in your case.
[SchemaName]: Replace this with the schema of the table, which is usually "dbo" for the default schema.
[TableName]: Replace this with the name of the table you want to query, which is "EmployeeSalary" in your case.
Here's an example using your provided information:
SELECT *
FROM [SQL Tutorial].dbo.EmployeeSalary
This query will select data from the "EmployeeSalary" table in the "SQL Tutorial" database. Make sure you are connected to the correct database server and that you have the necessary permissions to access the database and table.
