The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
点击查看答案
Principles of Marketing Marketing is the part of your business where money is made. In order to succeed in business, the following two principles of marketing should be kept in mind. First, customers are the mainstay of any business. Attracting customers to a business makes the difference between succeeding and failing. Therefore, the business needs to direct all activities towards satisfying the customers’ needs. If customers are satisfied, there is a chance that they will be retained for a long time and possibly permanently. Undoubtedly they are likely to talk to other potential customers. Another principle for a business is that profitable sales volume is more important than maximum sales volume. The profitable sales volume is the volume of sales that actually will earn a business the most profit. And the maximum sales volume simply refers to the biggest sum of retail sales. Since the aim of most businesses is to make as much profit as possible, businesses value profits more than the volume of sales. A large volume of sales may result in a low profit margin, therefore, it is important for marketers to focus on their profitable sales volume. Decide if each of the following statement is TRUE (T) or FALSE (F).1. In order to succeed in business, three principles of marketing should be kept in mind.()2. If customers are satisfied, they will be likely to encourage more people to buy the products or services.()3. The profitable sales volume is the volume of sales that will bring a business profit.()4. The maximum sales volume refers to the biggest sum of retail sales.()5. Profitable sales volume is as important as the maximum sales volume.()
听力原文：Under the documentary credit, banks are in no way concerned with the sales contract on which the credit may be based.(3)A．Banks will deal with the documentary credit along with the sales contract.B．Banks take no care of the sales contract while dealing with the documentary credit.C．Documentary credit and the sales contract are both important to banks.D．Banks will care for either the documentary credit or the sales contract.
你是一个出版公司的数据库开发人员，对特定的书名的每天的销售情况建立了如下的存储过程：CREATE PROCEDURE get_sales_for_titletitle varchar(80), @ytd_sales int OUTPUTASSELECT @ytd_sales = ytd_salesFROM titlesWHERE title = @titleIF @@ROWCOUNT = 0RETURN(-1)ELSERETURN(0)另外建立了一个脚本执行这个存储过程，如果执行成功，将返回对应于书名的每天的销售情况的报表，如果执行失败，将返回“No Sales Found”，怎样建立这个脚本？Ａ. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’, @ytdIF @retval < 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOＢ. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’, @ytd OUTPUTIF @retval < 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOＣ. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’,@retval OUTPUTIF @retval < 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOＤ. DECLARE @retval intDECLARE @ytd intEXEC @retval = get_sales_for_title ‘Net Etiquette’, @ytd OUTPUTIF @retval < 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GO
Which of the following statements about a Sales Catalog is TRUE？（）A、A store can only have one sales catalog.B、A sales catalog is used to bundle similar products.C、A sales catalog may be used to place a product in more than one category.D、Every store must have a sales catalog.
You are the network administrator for Company. Your Windows 2000 Professional computer contains a single hard disk configured with two NTFS partitions C and D. You want to move a folder named Sales from the C partition to a folder named Corp on the D partition. You want the files in the Sales folder to still be compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort. What should you do?（）A、 Back up the Sales Folder. Move the Sales folder to the Corp folder. Compress the Sales folder. B、 Back up the Sales folder. Copy the Sales folder to the Corp folder. C、 Copy the Sales folder to a second computer. Then move the Sales folder to the Corp folder. D、 Run the command xcopy.exe c:/Sales d:/Corp /S /C
Which statement is false about sales catalogs？（）A、Sales catalogs are used for customer display purposes.B、With a sales catalog products can be placed in many locations.C、If sales catalogs are used then it is not necessary to have a master catalog.D、Sales catalogs can be used to target specific customer segments.E、Sales catalogs can be used to control what products a customer can see.
