Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal
Solved
syntax error in MSSQL Stored Procedure
Posted on 2011-02-15
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
6 Comments
I can not see the name of the table you are creating:
create table
( Emplid nvarchar (7) NOT NULL ,
divisionID nvarchar (2) NOT NULL ,...
Should it not be:
create table PS_Slic_Employee_Data
( Emplid nvarchar (7) NOT NULL ,
divisionID nvarchar (2) NOT NULL ,...
If the table already exists, you will need to drop it first. I see you are truncating the table so the data loss in a drop table command will not be a problem
create table
( Emplid nvarchar (7) NOT NULL ,
divisionID nvarchar (2) NOT NULL ,...
Should it not be:
create table PS_Slic_Employee_Data
( Emplid nvarchar (7) NOT NULL ,
divisionID nvarchar (2) NOT NULL ,...
If the table already exists, you will need to drop it first. I see you are truncating the table so the data loss in a drop table command will not be a problem
Besides, you're missing a name for your table in the Create table script are you sure this isn't the actual cause of your error?
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
)
Featured Post
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article.
SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month10 days, 7 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.