The difference between sentences

yqh0130

BROW; LIST; SELECT; these three commands can query the desired number, what is the difference between them? Thank you

170385215

Look carefully at these three commands in the help.

In the real program Browse and List are almost useless.

我是杀人狂

Query statements generally use SELECT

cv4bf5d65fd

SELECT is a standard sql statement used more

kriesscoen

Browser can open a browsing data table window for you. It has its own output window, which is more difficult to control, so most
At the time, Developer is mainly used to view data in the development environment and use it to catch errors. Although it provides a lot of
But the emergence of GRID limits the use of BROWSER to this.

List has more functions. As mentioned above, it is rarely used in the program, but List is an excellent output to file
Tools, you can clearly see the current running environment, memory variables, database content, List Database can be listed
The whole thing in DBC.

As for Select, it is the standard selection statement of T-SQL, which is essentially different from Browser and List. It focuses on data processing.
Browser is the container, List is the environmental tool, and Select is the management data.

lancelot0229

Learn SQL, it's very useful, the other two are basically unnecessary

death01

The two you mentioned in T-SQL are almost unused. The most commonly used is Select. In T-SQL, it is very useful. It can be used to assign values ​​to variables and can also be used for queries. Basic operation. So I strongly recommend that you don't dig out those useless sentences, know that there is a lot of knowledge, you can't understand everything, learn how to choose!
Like it!