doubt in Database regarding the tables

See more:

SQL-Server

hi all,

i had created one table and i declare all the required columns needed.
but when i am writing the stored procedure i.e add,update inthat when i am using those variables it is showing error message as invalid columnname in add procedure and declare scalar variable in update procedure.

can u please tell what to do in table?suggest me. :)

UPDATE ConferenceRoom SET
        EmployeeName=@EmployeeName,
        PurposeOfBooking=@PurposeOfBooking,
        StartDate=@StartDate,
        EndDate=@EndDate,
        StartTime=@StartTime,
        EndTime=@EndTime,
        ConferenceRoom=@ConferenceRoom

SELECT TOP 1000 [EmployeeName]
      ,[PurposeOfBooking]
      ,[StartDate]
      ,[EndDate]
      ,[StartTime]
      ,[EndTime]
      ,[ConferenceRoom]
  FROM [HDCHRMSDB].[dbo].[ConferenceRoom]

dbo.ConferenceRoom
EmployeeName         varchar(MAX)    Checked
PurposeOfBooking     varchar(MAX)    Checked
StartDate             datetime       Checked
EndDate               datetime       Checked
StartTime             time(7)        Checked
EndTime               time(7)        Checked
ConferenceRoom        varchar(50)    Checked
        Unchecked

i declared in this way only.eventhough error is coming.