Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Reply
Invalid column ID in my sql query
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
narasiman rao
9y
472
1
Reply
My query as follows
Insert INTO Accounts_Entity(ID,Entity,Address1,Address2,Address3,Address4,Address5,Signature)
SELECT MAX(CAST(ID as INT)) + ,'HIMT','HIMT2','HIMT3','HIMT4','HIMT5','HIMT6','off'
Accounts_Entity
When i run the above sql query shows error as follows
Invalid column name 'ID'
Table structure as follows (Table Name Accounts_Entity)
Field Datatype
ID bigint
Entity varchar(50)
Address1 varchar(50)
Address2 varchar(50
Address3 varchar(50)
Address4 varchar(50)
Address5 varchar(50)
Signature V archar(50)
please help what is the mistake in my above sql query.
Regards,
Narasiman P.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
adding two queries in sql server
how to find sql server password of client macheine