I'm using SQL Server Management Studio 2008 and writing the next query

INSERT INTO Transaction (TransactionType, AccountID, HolderName, Amount, CurrDate) 
VALUES ('Cash Withdrawal', '25', 'abc', '1000', 'abc');

and also the script for table is

SELECT TOP 1000 [ID]
      ,[TransactionType]
      ,[AccountID]
      ,[HolderName]
      ,[Amount]
      ,[CurrDate]
  FROM [ATMSoftware].[dbo].[Transaction]

and ID may be the primary key and auto incremented. But I get the mistake around the place query

Incorrect syntax close to the keyword 'Transaction'.

Help me

Regards

[cde] is really a reserved keyword in SQL Server. You have to enclose the table title in Transaction to inform SQL Server it's a title and never a keyword:

[]

INSERT INTO [Transaction] (TransactionType,AccountID,HolderName,Amount,CurrDate) VALUES ('Cash Withdrawal','25','abc','1000','abc'); is really a reserved word. Place it in brackets.

Transaction

Much more doubt, put object names in brackets.

you have to enclosed your tablename that is Transaction with [ and ]. Transaction is really a reserved word.

INSERT INTO [Transaction](TransactionType, AccountID, HolderName, Amount, CurrDate) 
    VALUES ('Cash Withdrawal', '25', 'abc', '1000', 'abc');

This will help you meet your needs...Simply because Transaction is really a INSERT INTO [Transaction](TransactionType, AccountID, HolderName, Amount, CurrDate) VALUES ('Cash Withdrawal', '25', 'abc', '1000', 'abc'); in sql management. i additionally had similar problem once and KeyWord assisted me to leave it.

Election up or accept whether it matches your needs..