Incorrect syntax near '155411287'
Expand|Select|Wrap|Line Numbers
- Use [T-BAR]
- Create Table
- [T-BAR].[EBurt].[Addl_SE_FireAlarm]
- (ServiceOrderNumber VarChar(10) Null,
- StationID VarChar(24) Null,
- BilledAmount Money Not Null)
- Insert Into [EBurt].[Addl_SE_FireAlarm] (ServiceOrderNumber, StationID, BilledAmount)
- Values (144300176,NULL,(-$310.00)
- 155411287,NULL,$31.00)
Values (144300176,NULL,(-$310.00))
then it creates the table, no problem. But if I have more than 1 line of data, I get the error message.
If someone could help me, I'd appreciate it... Also, I'd rather read the file from my computer as opposed to a server. I thought this would be simple but I'm not having any luck. I'm new to this and can use some assistance...
Thanking you all in advance...