User Profile

PRODIKEY

Last Activity: Sep 29 '10, 12:01 PM

Joined: Sep 26 '10

Location:

PRODIKEY replied to Incorrect syntax near ','.

in SQL Server

Sep 29 '10, 12:01 PM
Thanks I found my mistake..

INSERT INTO TUTOR(TutorName ,TutorContact,Q ualification)
SELECT TutorName,Tutor Contact,Qualifi cation
FROM NEW_TUTOR;

*Remove the () under select statement

See more | Go to post
Leave a comment:

PRODIKEY started a topic Incorrect syntax near ','.

in SQL Server

Sep 26 '10, 01:35 PM

Incorrect syntax near ','.

I wanna to try BULK Insert from NEW_TUTOR to TUTOR and below are my sql statement :

Code:

CREATE Table TUTOR(
TutorName	varChar(100)	NOT NULL,
TutorContact	Numeric(8)	NOT NULL,
TutorAddress	Text		NULL,
Qualification	varChar(10)	NULL DEFAULT 'Degree',
CONSTRAINT	TutorNamePK	PRIMARY KEY(TutorName)
);

CREATE Table NEW_TUTOR(
TutorName	varChar(100)	NOT NULL,
TutorContact	Numeric(8)	NOT

Profile Sidebar

Leave a comment:

Incorrect syntax near ','.