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.