Last post May 23, 2018 01:37 AM by Deepak Panchal
May 22, 2018 05:18 AM|Preetham Y|LINK
insert into customer (Advance,status)values(@Advance,@status)where Name=@Name
i'm getting error in where clause..
May 22, 2018 06:22 AM|oned_gk|LINK
Inserting values is without where clause
insert into customer (Advance,status)values(@Advance,@status)
To insert from select query do like this
insert into customer (Advance,status) SELECT Advance, status FROM TABLE2 where Name=@Name
May 22, 2018 04:10 PM|limno|LINK
It is an UPDATE:
May 23, 2018 01:37 AM|Deepak Panchal|LINK
Hi Preetham Y,
You cannot use Where clause in Insert query.
You can use where clause if you are writing Insert Select query as other community member already informed you.
So you need to change your logic and try to write the query in a correct way to solve this issue.
You can get detailed information about 'Insert' from link below.