SQL Server COALESCE()函数创新应用

CREATE TABLE [Coalesce_Demo].[PayDay](
      [EmployeeID] [int] NOTNULL,
      [HourlyWage] [money] NULL,
      [HoursPerWeek] [int] NULL,
      [AmountPerPiece] [money] NULL,
      [PiecesThisWeek] [int] NULL,
      [WeeklySalary] [money] NULL,
      [CommissionThisWeek] [int] NULL,
 CONSTRAINT [PK_PayDay] PRIMARYKEYCLUSTERED 
(
      [EmployeeID] ASC
)WITH(PAD_INDEX  =OFF,STATISTICS_NORECOMPUTE  =OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS  =ON,ALLOW_PAGE_LOCKS  =ON)ON [PRIMARY]
)ON [PRIMARY]