1、 Find the name, loan number and loan amount of all customers; rename the column name loan_number as loan_id.
2、 Find the names of all customers whose street includes the substring “Main”.
3、Find all customers who have a loan, an account, or both:
4
(1) 利用SQL Server Management Studio创建一个名为employees的数据库。该数据库的主数据库文件逻辑名称为employees,初始大小为10MB,最大尺寸为无限大,增长速度为10%;数据库的日志文件逻辑名称为employees_log,初始大小为1MB,最大尺寸为5MB,增长速度为1MB。存放路径为D:\DATA\,其他均采用默认设置。
(2) 利用SQL Server Management Studio添加次要数据文件employee2和事物日志文件逻辑名称为