Hi
I have a table (see below) that has an AutoNotify field of type bit in it.
What I would like to do is create a SPROC that will change the AutoNotify
field.
If AutoNotify is 'Off' then turn it 'On' and vice versa. I will need to
pass in the EmployeeID to make sure only the relevant one is changed.
Thanks
Tim
****************************************************************************
**************
CREATE TABLE [dbo].[EmployeeInfo] (
[EmployeeID] [smallint] IDENTITY (1, 1) NOT NULL ,
[FirstName] [varchar] (50) NOT NULL ,
[LastName] [varchar] (50) NOT NULL ,
[Email] [varchar] (70) NULL ,
[Address] [varchar] (100) NULL ,
[City] [varchar] (50) NULL ,
[Province] [tinyint] NOT NULL ,
[PC] [varchar] (12) NULL ,
[Country] [varchar] (50) NULL ,
[TimeStamp] [smalldatetime] NOT NULL ,
[AutoNotify] [bit] NOT NULL
) ON [PRIMARY]
GO