Brock
asked on
syntax error in MSSQL Stored Procedure
Hi,
Attached you will find a stored procedure. All I want to do is add a new column to the create table but it keeps complaining the column is invalid name. I have tried different names but it still gives the error. Any help at this hour would be greatly appreciated.
Nigluc
code2.txt
Attached you will find a stored procedure. All I want to do is add a new column to the create table but it keeps complaining the column is invalid name. I have tried different names but it still gives the error. Any help at this hour would be greatly appreciated.
Nigluc
code2.txt
what's the column name you are trying to add?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
I am trying to add
Stat_Date datetime NOT NULL. which is for Start Date but I changed the name.
Sorry, I already had added the table name but did not put it in the upload.
Thanks,
Nigluc
I am trying to add
Stat_Date datetime NOT NULL. which is for Start Date but I changed the name.
Sorry, I already had added the table name but did not put it in the upload.
Thanks,
Nigluc
so is the code you have attached the code that gives an error?
This works just fine for me, what is the exact error and are you certain it is due to the Create table?
This works just fine for me, what is the exact error and are you certain it is due to the Create table?
create table MyTable
( Emplid nvarchar (7) NOT NULL ,
divisionID nvarchar (2) NOT NULL ,
Surname nvarchar (30) NOT NULL,
First_Name nvarchar (30) NOT NULL,
Term nvarchar (5) NOT NULL ,
Course nvarchar (10) NOT NULL ,
SWF_Section_Size int NULL ,
Classification nvarchar(3),
End_Date datetime NOT NULL ,
Start_Date datetime NOT NULL,
Sect nvarchar (2) NULL ,
Assigned_Teaching_Hours_TCH int NULL,
Preparation nvarchar(3) Null,
Evaluation nvarchar (3) NULL,
TCW int NOT Null,
Course_Preps int NULL,
TCH_Sum int Null
)
ASKER
Thank you to both,
I had renamed the table so the Table Create X was not the same as what I was inserting into and it gave a misleading error.
Nigluc
I had renamed the table so the Table Create X was not the same as what I was inserting into and it gave a misleading error.
Nigluc