[They all say that select * is not good, ...], Select ..
If you ask any experienced Database staff, they will tell you that SELECT * FROM... is not a good idea, so it is best not to use it. Today, I spent several hours testing some places where a select * error occurred. Then I found:
Rennie MoodleyTo help me understand what problems I found after the occurrence, help me create the following sample code, then 2 people and Christopher Swart improve the sample and find something more strange, you will also see below.
Sample Setup in the installer, you can use any Sample database that contains all the code to create a sampledb and drag and drop it to the end. |
USE [master]
- GO
- -- Create sample database
- Create database [SampleDb]
- CONTAINMENT = NONE
- ON PRIMARY
- (NAME = n' sampledb', FILENAME = n' C: \ SQL \ Database Engine \ Data \ SampleDb. mdf ', SIZE = 4096KB, FILEGROWTH = 1024KB)
- LOG ON
- (NAME = n' SampleDb _ log', FILENAME = n' C: \ SQL \ Database Engine \ log \ SampleDb_log.ldf ', SIZE = 1024KB, FILEGROWTH = 10%)
- GO
Read the full text
More java, java learning, and java interview questionsHttp://techfoxbbs.com