I am using SQL Server Management Studio 2008 and writing the following query
INSERT INTO Transaction (TransactionType, AccountID, HolderName, Amount, CurrDate)
VALUES ('Cash Withdrawal', '25', 'abc', '1000', 'abc');
and the script for table is
SELECT TOP 1000 [ID]
,[TransactionType]
,[AccountID]
,[HolderName]
,[Amount]
,[CurrDate]
FROM [ATMSoftware].[dbo].[Transaction]
and ID
is the primary key and auto incremented. But I am getting the error on the insert query
Incorrect syntax near the keyword 'Transaction'.
Please help me
Regards
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…