Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
After checking what was happening we noticed a user decided to use "/" and iserted ion the transaction code. So when the transacion is saved via the apps, we get the error above:
Msg 213, Level 16, State 1, Line 29 Column name or number of supplied values does not match table definition.
INSERT INTO tablename VALUES ('TRAN/1002',0,0,0)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.