FinanceClass: Finance 401–answer Key
Array If any errors oc cur in the TRY block, execution is diverted to the CATCH block and the error can be dealt with while error functions can be used to provide the detailed error information. The table schema follows:create table dbo.Titles(TitleID int Primary Key identity,TitleName nvarchar(128) NOT NULL,Price money NULL constraint CHK_Price check (Price > 0))create table dbo.Authors(Authors_ID int primary key identity,au_fname nvarchar(32) NULL,au_lname nvarchar(64) NULL,TitleID int constraint FK_TitleID foreign keyreferences Titles(TitleID),CommissionRating int constraint CHK_ValidateCommissionRating Check (CommissionRating between 0 and 100))create table dbo.Application_Error_Log(tablename sysname,userName sysname,errorNumber int,errorSeverity int,errorState int,errorMessage varchar(4000))Exception Handling under SQL Server 2000As you will see, this stored procedures contains the unstructured error handling we’ve been using prior to the arrival of SQL 2005.create proc P_Insert_New_BookTitle_2K(@TitleName nvarchar(128),@Price money,@au_fname nvarchar(32),@au_name nvarchar(64),@CommissionRating int)asdeclare @err int,@tablename sysnamebegin transactioninsert dbo.Titles (TitleName, Price)values (@TitleName, @Price)select @err = @@errorif @err 0begin select @tablename = ‘titles’ GOTO ERROR_HANDLERendinsert dbo.Authors (au_fname, au_lname, TitleID, CommissionRating)values (@au_fname, @au_fname, @@IDENTITY, @CommissionRating)if @err 0begin select @tablename = ‘authhors’ GOTO ERROR_HANDLERendGOTO EXIT_ProcERROR_HANDLER:ROLLBACK TRANSACTION– Log the errorinsert dbo.Application_Error_Log (tableName, UserName, errorNumber, errorSeverity, errorState)values (@tableName, suser_sname(), @err, 0, 0)EXIT_Proc:commit tranWe’ve seen this code before! CATCH block and structured error handling:create proc P_Insert_New_BookTitle_2K5(@TitleName nvarchar(128),@Price money,@au_fname nvarchar(32),@au_name nvarchar(64),@CommissionRating int)asdeclare @err int,@tablename sysname,@errormessage nvarchar(2000)BEGIN TRYbegin transactionselect @errormessage = ‘insert into Titles table failed’, @tablename = ‘Titles’insert dbo.Titles (TitleName, Price) values (@TitleName, @Price)select @errormessage = ‘insert into Authors table failed’, @tablename = ‘Authors’insert dbo.Authors (au_fname, au_lname, TitleID, CommissionRating) values (@au_fname, @au_fname, @@IDENTITY, @CommissionRating)commit transactionEND TRYBEGIN CATCHROLLBACK TRANSACTION– Log the errorinsert dbo.Application_Error_Log (UserName, tableName, errorNumber, errorSeverity, errorState, errorMessage)values (suser_sname(), @tableName, ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_MESSAGE())RAISERROR (@errormessage, 16,1)END CATCHNotice the SQL 2005 exception handling code is much more streamlined and therefore more readable and maintainable.
link
Taurek (1977) âShould the Numbers Count?â Philosophy and Public Affairs 6:4 293-316F. Kamm (1985) âEqual Treatment and Equal Chancesâ Philosophy & Public Affairs 14:2 177-194Supplementary: D. Parfit (1979) âCorrespondenceâ Philosophy and Public Affairs 8:4 393-397 G. Sanders (1988) âWhy the Numbers Should Sometimes Countâ Philosophy and Public Affairs 17:1 3-14 I. Strudler (2003) âCan a Nonconsequentialist Count Lives?â Philosophy and Public Affairs 31:1 71-94F.
link
-ne West Virginia over Louisville^Virginia Tech over Miami*Boston College over Wake ForestFlorida State over VirginiaLSU over TennesseeSouth Carolina over Arkansas*^Oklahoma over Texas A&MNebraska over Missouri*Wisconsin over Penn StateOregon over WashingtonGatorZoneFlorida 27 Vandy 17Florida 28 Vandy 14*Florida 31 Vandy 17^*Sudhan’s pick^Pal’s pickLast week: 6-4 Overall: 66-24, 73%Sudhan- Last week: 4-6 Overall: 58-32, 64%Pal- Last week: 5-5 Overall: 61-29, 68%
link
-ne
Being a Green Consumer [GREENY] means that you will do as much as you can to reduce waste and promote positive environmental decisions in your home, school or workplace. In this section, I will offer Wise Consumer choices and simple tasks to help you become more aware of how you deal with waste.***************************************************Throwing it away is the traditional way of dealing with most waste, but only for an Ontario of the past
-ne BASICSname: JIMalias: BATMANage: 22hometown: NORMAL, ILLINOISfamily: DAD, MOM, JASON (19), TYLER (17), BRIAN (14), 3 CATS & a DOGEDUCATIONschool: ILLINOIS STATE UNIVERSITYmajor: ELEMENTARY EDUCATIONprojected graduation date: PENDINGhopeful graduation date: DECEMBER 2007ALLEGIANCESNFL: CHICAGO BEARSNCAA FB: NOTRE DAME FIGHTING IRISH & ISU REDBIRDSMLB: THE WORLD CHAMPION ST.
link
Said âI love youâ and meant it - everyday09. Taken a trip in a hot air balloon22. Adopted an accent for an entire day - I do a generic Southern quite well, family roots and all, not too mention a good Baptist preacher imitation, enough to scare people38. Taken care of someone who was drunk.42. Visited the Great Wall of China67. Gotten married - not legally73. Gone without food for 5 days - during my self-punishing Roman Catholic days77. Been to Las Vegas - but only on the way through, gambling is boring in my estimation, maybe someday we’ll visit for the shows86. Kissed on the first date - and should have left it at that89. Taken an exotic bicycle tour in a foreign country100. Sang loudly in the car, and didnât stop when you knew someone was looking103. Had a facial part pierced other than your ears - no, but I’ve appreciated having my former boyfriend’s PA in my face - does that count as piercing?116. Fired a rifle, shotgun, or pistol - all three117. Visited more foreign countries than U.S. states124. Taken a canoe trip that lasted more than 2 days126. Changed someoneâs mind about something you care deeply about - but not by intellectual debate130. Read The Iliad - and the Odyssey and the Aeneid135. Selected one âimportantâ author who you missed in school, and read - James Baldwin among others136. Communicated with someone without sharing a common spoken language139. Sold your own artwork to someone who didnât know you145. Dyed your hair - purple was my favorite147.
link
-ne Multiple Choice (2 points each) 1.c 25.c 49.d 2.e 26.c 50.c 3.c 27.a 51.b 4.b 28.e 52.a 5.b 29.d 53.c 6.a 30.drop 54.d 7.b 31.a 55.a 8.cd(either) 32.a 56.e 9.
link
Array If any errors oc cur in the TRY block, execution is diverted to the CATCH block and the error can be dealt with while error functions can be used to provide the detailed error information. The table schema follows:create table dbo.Titles(TitleID int Primary Key identity,TitleName nvarchar(128) NOT NULL,Price money NULL constraint CHK_Price check (Price > 0))create table dbo.Authors(Authors_ID int primary key identity,au_fname nvarchar(32) NULL,au_lname nvarchar(64) NULL,TitleID int constraint FK_TitleID foreign keyreferences Titles(TitleID),CommissionRating int constraint CHK_ValidateCommissionRating Check (CommissionRating between 0 and 100))create table dbo.Application_Error_Log(tablename sysname,userName sysname,errorNumber int,errorSeverity int,errorState int,errorMessage varchar(4000))Exception Handling under SQL Server 2000As you will see, this stored procedures contains the unstructured error handling we’ve been using prior to the arrival of SQL 2005.create proc P_Insert_New_BookTitle_2K(@TitleName nvarchar(128),@Price money,@au_fname nvarchar(32),@au_name nvarchar(64),@CommissionRating int)asdeclare @err int,@tablename sysnamebegin transactioninsert dbo.Titles (TitleName, Price)values (@TitleName, @Price)select @err = @@errorif @err 0begin select @tablename = ‘titles’ GOTO ERROR_HANDLERendinsert dbo.Authors (au_fname, au_lname, TitleID, CommissionRating)values (@au_fname, @au_fname, @@IDENTITY, @CommissionRating)if @err 0begin select @tablename = ‘authhors’ GOTO ERROR_HANDLERendGOTO EXIT_ProcERROR_HANDLER:ROLLBACK TRANSACTION– Log the errorinsert dbo.Application_Error_Log (tableName, UserName, errorNumber, errorSeverity, errorState)values (@tableName, suser_sname(), @err, 0, 0)EXIT_Proc:commit tranWe’ve seen this code before! CATCH block and structured error handling:create proc P_Insert_New_BookTitle_2K5(@TitleName nvarchar(128),@Price money,@au_fname nvarchar(32),@au_name nvarchar(64),@CommissionRating int)asdeclare @err int,@tablename sysname,@errormessage nvarchar(2000)BEGIN TRYbegin transactionselect @errormessage = ‘insert into Titles table failed’, @tablename = ‘Titles’insert dbo.Titles (TitleName, Price) values (@TitleName, @Price)select @errormessage = ‘insert into Authors table failed’, @tablename = ‘Authors’insert dbo.Authors (au_fname, au_lname, TitleID, CommissionRating) values (@au_fname, @au_fname, @@IDENTITY, @CommissionRating)commit transactionEND TRYBEGIN CATCHROLLBACK TRANSACTION– Log the errorinsert dbo.Application_Error_Log (UserName, tableName, errorNumber, errorSeverity, errorState, errorMessage)values (suser_sname(), @tableName, ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_MESSAGE())RAISERROR (@errormessage, 16,1)END CATCHNotice the SQL 2005 exception handling code is much more streamlined and therefore more readable and maintainable.
link
Taurek (1977) âShould the Numbers Count?â Philosophy and Public Affairs 6:4 293-316F. Kamm (1985) âEqual Treatment and Equal Chancesâ Philosophy & Public Affairs 14:2 177-194Supplementary: D. Parfit (1979) âCorrespondenceâ Philosophy and Public Affairs 8:4 393-397 G. Sanders (1988) âWhy the Numbers Should Sometimes Countâ Philosophy and Public Affairs 17:1 3-14 I. Strudler (2003) âCan a Nonconsequentialist Count Lives?â Philosophy and Public Affairs 31:1 71-94F.
link
-ne West Virginia over Louisville^Virginia Tech over Miami*Boston College over Wake ForestFlorida State over VirginiaLSU over TennesseeSouth Carolina over Arkansas*^Oklahoma over Texas A&MNebraska over Missouri*Wisconsin over Penn StateOregon over WashingtonGatorZoneFlorida 27 Vandy 17Florida 28 Vandy 14*Florida 31 Vandy 17^*Sudhan’s pick^Pal’s pickLast week: 6-4 Overall: 66-24, 73%Sudhan- Last week: 4-6 Overall: 58-32, 64%Pal- Last week: 5-5 Overall: 61-29, 68%
link
-ne
Being a Green Consumer [GREENY] means that you will do as much as you can to reduce waste and promote positive environmental decisions in your home, school or workplace. In this section, I will offer Wise Consumer choices and simple tasks to help you become more aware of how you deal with waste.***************************************************Throwing it away is the traditional way of dealing with most waste, but only for an Ontario of the past
-ne BASICSname: JIMalias: BATMANage: 22hometown: NORMAL, ILLINOISfamily: DAD, MOM, JASON (19), TYLER (17), BRIAN (14), 3 CATS & a DOGEDUCATIONschool: ILLINOIS STATE UNIVERSITYmajor: ELEMENTARY EDUCATIONprojected graduation date: PENDINGhopeful graduation date: DECEMBER 2007ALLEGIANCESNFL: CHICAGO BEARSNCAA FB: NOTRE DAME FIGHTING IRISH & ISU REDBIRDSMLB: THE WORLD CHAMPION ST.
link
Said âI love youâ and meant it - everyday09. Taken a trip in a hot air balloon22. Adopted an accent for an entire day - I do a generic Southern quite well, family roots and all, not too mention a good Baptist preacher imitation, enough to scare people38. Taken care of someone who was drunk.42. Visited the Great Wall of China67. Gotten married - not legally73. Gone without food for 5 days - during my self-punishing Roman Catholic days77. Been to Las Vegas - but only on the way through, gambling is boring in my estimation, maybe someday we’ll visit for the shows86. Kissed on the first date - and should have left it at that89. Taken an exotic bicycle tour in a foreign country100. Sang loudly in the car, and didnât stop when you knew someone was looking103. Had a facial part pierced other than your ears - no, but I’ve appreciated having my former boyfriend’s PA in my face - does that count as piercing?116. Fired a rifle, shotgun, or pistol - all three117. Visited more foreign countries than U.S. states124. Taken a canoe trip that lasted more than 2 days126. Changed someoneâs mind about something you care deeply about - but not by intellectual debate130. Read The Iliad - and the Odyssey and the Aeneid135. Selected one âimportantâ author who you missed in school, and read - James Baldwin among others136. Communicated with someone without sharing a common spoken language139. Sold your own artwork to someone who didnât know you145. Dyed your hair - purple was my favorite147.
link
-ne Multiple Choice (2 points each) 1.c 25.c 49.d 2.e 26.c 50.c 3.c 27.a 51.b 4.b 28.e 52.a 5.b 29.d 53.c 6.a 30.drop 54.d 7.b 31.a 55.a 8.cd(either) 32.a 56.e 9.
link