You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()
A. Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
B. Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data.
D. Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data, and to insert the data into the database.
()是黄河干流上一座集减淤、防洪、供水灌溉、发电等为一体的大型综合水利工程,可使黄河下游花园口的防洪标准由六十年一遇提高到千年一遇,年平均发电量51亿千瓦时。这项工程于2001年12月31日全部竣工。
A. 三峡工程
B. 小浪底水利枢纽工程
C. 三门峡水利枢纽工程