When i write the query like this:
CREATE PROCEDURE [dbo].[ItemsSave]
SET NOCOUNT ON;
INSERT INTO [dbo].[MAST](ACCNO)
i am getting error :
Incorrect syntax near the keyword 'WHERE'.
Please help me to solve this
Why are you using
INSERT? You are actually updating the table, aren't you? You should use
When you need to add new enregistrement use Insert, but when you need to update a value use Update.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)