Instance learning SQL internal connection and external connection

This afternoon I summarized the stored procedure. One of the problems encountered was the internal connection problem. Although I have learned the internal connection before, I have never used it, so I only know a few simple concepts. I used it now, but I don't understand it very well. So let's summarize it.

In summary, the internal connection cannot be used!

To sum up, it is better to use an instance to make yourself better understand.

Below are some T-SQL statements I have used, including statements such as opening a database and creating a table. You only need to execute the corresponding parts in sequence. After the process is completed, you will understand what the internal connection is and what the external connection is! If you want to know more about internal connections and external connections, try it on your own!

Note:

1. After uploading an SQL query file, you must first open your SQL Server and connect to it.

2. After the connection is successful, double-click the file to open it automatically.

3. As long as you have a little SQL foundation, you should know that you cannot directly execute all of them. You need to execute them step by step so that you can see the differences between them!

If you talk more about it, try it yourself! The rest is yours!

 

Verify the t_ SQL statement of the internal connection and external connection instances. The SQL download link