Click here to Skip to main content
12,398,557 members (56,679 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL
When i write the query like this:



CREATE PROCEDURE [dbo].[ItemsSave]
    @xml XML
AS
BEGIN
    SET NOCOUNT ON;
 
    INSERT INTO [dbo].[MAST](ACCNO)
    VALUES('Y')
    WHERE ACCNO='099035516'
END


i am getting error :
Incorrect syntax near the keyword 'WHERE'.

Please help me to solve this
Posted 8-Apr-13 22:07pm
Comments
Anurag Sinha V 9-Apr-13 4:18am
   
use an Update statement with the where clause...
or use Insert statement without the where clause if its a new insert to the table..

-Regards
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Why are you using INSERT? You are actually updating the table, aren't you? You should use UPDATE.
  Permalink  
Comments
Aarti Meswania 9-Apr-13 4:19am
   
5+ :)
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

When you need to add new enregistrement use Insert, but when you need to update a value use Update.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 9 Apr 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100