| cassie 2001-08-20, 1:20 pm |
| You are building a prototype for a new SQL Server 2000 db. You have built several new tables with scripts like this:
CREATE TABLE
newtable
(pk_uniqueidentifier,
productname varchar(30),
catalogshortid int,
catalogfullid int,
catalogfullid uniqueidentifier,
price float)
Each script has different table and column names. The developers are building generic queries that can be run on all these similar tables. Because the column names are different in each table, they want to be able to extract the primary key values without calling the column by name. They will use the ROWGUIDCOL keyword in their queries.
What is true about there approach to the generic queries?
A. Set a db option
B. Add a keyword to the CREATE PROC statement
C. Create a dynamic name for each cursor
D. Set a server option
E. Change the cursor's scope |