INSERT statement contains fewer items than the insert list

jdpc91 / redabitsScabcr

1 stars 0 forks source link

INSERT statement contains fewer items than the insert list #3

Closed shackra closed 6 years ago

shackra commented 6 years ago

Al ejecutar sqlcmd -S localhost -U SA -P u2ykHVe3XMSPzvL9 -i sql/6_create_trigger_factura.sql el siguiente error aparece:

Changed database context to 'Moderna'.
Msg 120, Level 15, State 1, Server ab8fd84231f0, Procedure INSERT_COMPROBANTE, Line 21
The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.

djhvscf commented 6 years ago

Fixed with https://github.com/jdpc91/redabitsScabcr/commit/7fcb38b5e2d3512bf98ef362f51fba649fe1dccd